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()
})
 


what will be the insert query??
Was this page helpful?