ㅂㅈ
Tables (8)
address
- addr_key (Key) — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
- zipcode — VARCHAR2(300) — NOT NULL
- addr — VARCHAR2(300) — NOT NULL
- addrDetail — VARCHAR2(300) — NOT NULL
- req — VARCHAR2(300)
admin (Untitled)
- admin_id — NUMBER — Primary key — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- adminName — VARCHAR2(150)
- adminpw — VARCHAR2(150)
- auth — NUMBER
cart
- cart_id (Key) — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- quantity — NUMBER
category
- category_key — NUMBER — Primary key — NOT NULL
- category_name — VARCHAR2(100)
order (Untitled2)
- order_key — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
- price — NUMBER
- orderDate — DATE
- zipcode — VARCHAR2(300)
- addr — VARCHAR2(300)
product
- product_id — NUMBER — Primary key — NOT NULL
- category_key — NUMBER — Foreign key → category.category_key — NOT NULL
- product_name — VARCHAR2(200) — NOT NULL
- description — VARCHAR2(300)
- thumb — VARCHAR2(200)
- review — NUMBER
review
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
- admin_id — NUMBER — Foreign key → admin.admin_id — NOT NULL
- product_id — NUMBER — Foreign key → product.product_id — NOT NULL
- star — NUMBER
- detailReview — VARCHAR2(300)
- simpleReview — VARCHAR2(200)
- photo — VARCHAR2(200)
users
- user_id — NUMBER — Primary key — NOT NULL
- usertype — VARCHAR2(10)
- username — VARCHAR2(150) — NOT NULL
- password — VARCHAR2(150) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- phone — VARCHAR2(100) — NOT NULL