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)