export const membershipSubscriptions = pgTable(
"membership_subscriptions",
withTimestamps({
id: uuid("id").primaryKey(),
// ...
}),
);
export const membershipSubscriptionMembers = pgTable(
"membership_subscription_members",
{
membershipSubscriptionId: uuid("membership_subscription_id")
.references(() => membershipSubscriptions.id)
.notNull(),
memberId: uuid("customer_id")
.references(() => customers.id)
.notNull(),
},
(table) => [
primaryKey({
columns: [table.membershipSubscriptionId, table.memberId],
}),
],
);
export const membershipSubscriptionActivityTypes = pgTable(
"membership_subscription_activity_types",
withTimestamps({
membershipSubscriptionId: uuid("membership_subscription_id")
.references(() => membershipSubscriptions.id)
.notNull(),
activityTypeId: uuid("activity_type_id")
.references(() => activityTypes.id)
.notNull(),
}),
(table) => [
primaryKey({
columns: [table.membershipSubscriptionId, table.activityTypeId],
}),
],
);
export const membershipSubscriptions = pgTable(
"membership_subscriptions",
withTimestamps({
id: uuid("id").primaryKey(),
// ...
}),
);
export const membershipSubscriptionMembers = pgTable(
"membership_subscription_members",
{
membershipSubscriptionId: uuid("membership_subscription_id")
.references(() => membershipSubscriptions.id)
.notNull(),
memberId: uuid("customer_id")
.references(() => customers.id)
.notNull(),
},
(table) => [
primaryKey({
columns: [table.membershipSubscriptionId, table.memberId],
}),
],
);
export const membershipSubscriptionActivityTypes = pgTable(
"membership_subscription_activity_types",
withTimestamps({
membershipSubscriptionId: uuid("membership_subscription_id")
.references(() => membershipSubscriptions.id)
.notNull(),
activityTypeId: uuid("activity_type_id")
.references(() => activityTypes.id)
.notNull(),
}),
(table) => [
primaryKey({
columns: [table.membershipSubscriptionId, table.activityTypeId],
}),
],
);