is this right way ?

// intity.schema.js

import { pgTable, uuid, varchar } from "drizzle-orm/pg-core";

export const entities = pgTable('entities', {
id: uuid('id').primaryKey().defaultRandom(),
srcId: uuid('src_id').unique().notNull(),
entityType: varchar('entity_type', { length: 16 }).notNull(),
entityDescription: varchar('description', { length: 255 }),
})

export const entityAttribute = pgTable('entity_attribute', {
id: uuid('id').primaryKey().defaultRandom(),
entityId: uuid('entity_id').references(() => entities.id).notNull(),
attrLabel: varchar('attribute_label', { length: 16 }).unique().notNull(),
})

export const entityAttrValue = pgTable('entity_attribute_value', {
// id: uuid('id').primaryKey().defaultRandom(),
entityAttrId: uuid('id').primaryKey().references(() => entityAttribute.id), // id
entityId: uuid('entity_id').references(() => entities.id).notNull(),
entityAttrValue: varchar('entity_attribute_value', { length: 100 }).notNull()
})

// intity.schema.js

import { pgTable, uuid, varchar } from "drizzle-orm/pg-core";

export const entities = pgTable('entities', {
id: uuid('id').primaryKey().defaultRandom(),
srcId: uuid('src_id').unique().notNull(),
entityType: varchar('entity_type', { length: 16 }).notNull(),
entityDescription: varchar('description', { length: 255 }),
})

export const entityAttribute = pgTable('entity_attribute', {
id: uuid('id').primaryKey().defaultRandom(),
entityId: uuid('entity_id').references(() => entities.id).notNull(),
attrLabel: varchar('attribute_label', { length: 16 }).unique().notNull(),
})

export const entityAttrValue = pgTable('entity_attribute_value', {
// id: uuid('id').primaryKey().defaultRandom(),
entityAttrId: uuid('id').primaryKey().references(() => entityAttribute.id), // id
entityId: uuid('entity_id').references(() => entities.id).notNull(),
entityAttrValue: varchar('entity_attribute_value', { length: 100 }).notNull()
})

what will be the insert query??
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server