Mall
Tables (8)
Basket
- OrderNum — NUMBER — Primary key — NOT NULL
- productID (product_id) — VARCHAR2(10) — Foreign key → Product.product_id — NOT NULL
- memid — varchar(20) — Foreign key → member.memid — NOT NULL
- Quantity — NUMBER
PaymentInfo
- paymentNum — NUMBER — Primary key — NOT NULL
- memid — varchar(20) — Foreign key → member.memid — NOT NULL
- email — varchar(30) — NOT NULL
- phone — varchar(13) — NOT NULL
- address — varchar(100)
- payment — varchar(50)
- product_id — VARCHAR2(999) — NOT NULL
- Quantity — VARCHAR2(999) — NOT NULL
- product_name — VARCHAR2(999) — NOT NULL
- product_price — VARCHAR2(999) — NOT NULL
- Money — VARCHAR2(999) — NOT NULL
- sumMoney — int — NOT NULL
- fee — int
- allSum — int — NOT NULL
- paymentDate — DATE
Product
- product_id — VARCHAR2(10) — Primary key — NOT NULL
- product_name — VARCHAR2(50) — NOT NULL
- product_price — int — NOT NULL
- product_detail — VARCHAR2(300)
- product_keyword — VARCHAR2(200) — NOT NULL
- product_url — VARCHAR2(100)
contents_board
- contents_num — NUMBER — Primary key — NOT NULL
- contents_subject — VARCHAR2(100)
- contents_creator — VARCHAR2(100)
- contents_src — VARCHAR2(100)
- contents_file — VARCHAR2(100)
jjim
- rec_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
- contents_num — NUMBER — Foreign key → contents_board.contents_num — NOT NULL
jjim_product
- rec_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
- product_id — VARCHAR2(10) — Foreign key → Product.product_id — NOT NULL
member
- memid — varchar(20) — Primary key — NOT NULL
- pw — varchar(20) — NOT NULL
- email — varchar(30) — NOT NULL
- phone — varchar(13) — NOT NULL
- address — varchar(100)
- payment — varchar(50)
- memberDate — DATE
review_board
- board_num — NUMBER — Primary key — NOT NULL
- board_id (memid) — varchar(20) — Foreign key → member.memid — NOT NULL
- board_subject — VARCHAR2(100)
- board_content — VARCHAR2(2000)
- board_file — VARCHAR2(100)
- board_re_ref — NUMBER
- board_re_lev — NUMBER
- board_re_seq — NUMBER
- board_count — NUMBER
- board_date — DATE