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