Project

Tables (7)

TV (세부_TV)

  • TVcode — varchar(50) — Primary key — NOT NULL
  • TVbrand — varchar(50)
  • screensize — int
  • quality — varchar(50)
  • resolution — varchar(50)
  • shape — varchar(50)
  • TVcolor — varchar(50)
  • function — varchar(50)

book

  • bookcode — varchar(50) — Primary key — NOT NULL
  • publisher — varchar(50)
  • bookname — varchar(50)
  • bookperiod — data

category

  • categoryID — int — Primary key — NOT NULL
  • productID — varchar2(50) — Foreign key → product.productID — NOT NULL
  • category_B — varchar2(50)
  • category_M — varchar2(50)

cloth

  • clothcode — varchar(50) — Primary key — NOT NULL
  • clothbrand — varchar(50)
  • sleeve — varchar(50)
  • neck — varchar(50)
  • pattern — varchar(50)
  • length — varchar(50)
  • colthcolor — varchar(50)
  • material — varchar(50)

meta

  • meta_ID — int — Primary key — NOT NULL
  • productID — varchar2(50) — Foreign key → product.productID — NOT NULL
  • clothcode — varchar(50) — Foreign key → cloth.clothcode — NOT NULL
  • bookcode — varchar(50) — Foreign key → book.bookcode — NOT NULL
  • TVcode — varchar(50) — Foreign key → TV.TVcode — NOT NULL

product

  • productID — varchar2(50) — Primary key — NOT NULL
  • price — int
  • manufacturer — varchar2(50)
  • Information — varchar2(50)
  • productname — varchar2(50)
  • registrationdate — date

review

  • reviewID — varchar(50) — Primary key — NOT NULL
  • productID — varchar(50) — Foreign key → product.productID — NOT NULL
  • scope — varchar2(50)
  • recommend — varchar(50)
  • review — varchar2(50)