hi_jewel
Tables (6)
Question post
- id — uuid — Primary key — NOT NULL
- type (notice/qna/comment) — varcahr
- replyContact (replyContact/userEmail for notice) — varchar
- createDate — Date
- updateDate — Date
- parentPostId (nullable) — varchar
- title — varchar
- content — text
- userEmail (userEmail/ or input of replay contact) — varchar — Foreign key → user.id — NOT NULL
product (Untitled3)
- id — varchar — Primary key — NOT NULL
- id (typeId) — UUID — Foreign key → product_type.id — NOT NULL
- id (userId) — uuid — Foreign key → user.id — NOT NULL
- title — varchar
- description (description\) — varchar
- imgSrc — varchar
- updateDate — Date
- createDate — Date
- isPresented — char
product_type (Untitled)
- id — UUID — Primary key — NOT NULL
- label — varchar
- description — varchar
- imgSrc — varchar
- isPresented — char
product_type_order
- id (ProductTypeId) — UUID — Foreign key → product_type.id — NOT NULL
- order — Integer
statistic
- date (statDate) — varchar — Primary key — NOT NULL
- productId — varchar — Foreign key → product.id — NOT NULL
- type — varchar
- count — number
user (Untitled2)
- id — uuid — Primary key — NOT NULL
- email (Field) — varchar
- type (email) — varchar
- pw — varchar
- role — varchar
- createDate — Date
- updateDate — Date