ㅁㅇㄴㄹ
Tables (13)
bk_cate
- cate_id — number — Primary key — NOT NULL
- cate — varchar2(50)
book
- bk_id — varchar2(50) — Primary key — NOT NULL
- cate_id — number — NOT NULL
- bk_name — varchar2(50) — NOT NULL
- bk_price — number — NOT NULL
- bk_quantity — number — NOT NULL
- bk_author — varchar2(50)
- bk_pub — varchar2(50)
- bk_published — varchar2(50) — NOT NULL
cart
- cart_id — number — Primary key — NOT NULL
- u_id — varchar2(50) — NOT NULL
cart_item
- cart_item_id — number — Primary key — NOT NULL
- cart_id — number — NOT NULL
- pro_id — varchar2(50) — NOT NULL
- quantity — number — NOT NULL
membership
- grade — varchar2(50) — Primary key — NOT NULL
- mem_disc — varchar2(10)
- u_id — varchar2(50) — NOT NULL
order_item
- order_item_id — number — Primary key — NOT NULL
- order_id — number — NOT NULL
- cart_item_id — number — NOT NULL
- quantity — number — NOT NULL
order_table
- order_id — number — Primary key — NOT NULL
- u_id — varchar2(50) — NOT NULL
- order_status — varchar2(50) — NOT NULL
- total_amount — number — NOT NULL
product
- pro_id — varchar2(50) — Primary key — NOT NULL
- pro_grade — varchar2(50)
- bk_id — varchar2(50)
- re_num — number
- sup_id — varchar2(50)
review
- re_num — number — Primary key — NOT NULL
- u_id — varchar2(50) — NOT NULL
- re_title — varchar2(50)
- re_body — varchar2(255)
- re_grade — number(5)
- re_date — date
review_comment
- cmt_id — varchar2(50) — Primary key — NOT NULL
- u_id — varchar2(50) — NOT NULL
- re_num — number — NOT NULL
- cmt_body — varchar2(255)
- cmt_date — date
sup_cate
- cate_id — number — Primary key — NOT NULL
- cate — varchar2(50)
supplies
- sup_id — varchar2(50) — Primary key — NOT NULL
- cate_id — number — NOT NULL
- Field — varchar2(50)
- Field4 — number
- Field2 — varchar2(50)
- Field3 — varchar2(50)
user_info
- u_id — varchar2(50) — Primary key — NOT NULL
- u_name — varchar2(50)
- u_login — varchar2(50)
- u_pw — varchar2(50)
- u_mail — varchar2(50)
- u_addr — varchar2(255)