export const authors = mysqlTable(
"authors",
{
publicationId: varchar("publication_id", { length: 64 }).references(() => publications.id),
authorID: varchar("author_id", { length: 10 }).references(() => faculty.id),
orcidId: varchar("orcid_id", { length: 64 }).references(() => t2.orcidId), //Added new column
},
(table) => {
return {
pk: primaryKey(table.publicationId, table.authorUFID), // removed line
pk: primaryKey({ columns: [table.publicationId, table.authorID, table.orcidId], name: "authors_pk" }), // Added line
};
}
);
export const authors = mysqlTable(
"authors",
{
publicationId: varchar("publication_id", { length: 64 }).references(() => publications.id),
authorID: varchar("author_id", { length: 10 }).references(() => faculty.id),
orcidId: varchar("orcid_id", { length: 64 }).references(() => t2.orcidId), //Added new column
},
(table) => {
return {
pk: primaryKey(table.publicationId, table.authorUFID), // removed line
pk: primaryKey({ columns: [table.publicationId, table.authorID, table.orcidId], name: "authors_pk" }), // Added line
};
}
);