a
Tables (7)
cart
- cart__id (cart_id) — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.member_id — NOT NULL
- reg_time — datetime
- update_time — datetme
- created_by — varchar(255)
- modified_by — varchar(255)
cart_item
- cart_item_id — long — Primary key — NOT NULL
- cart__id (cart_id) — long — Foreign key → cart.cart__id — NOT NULL
- item_id (item_id2) — long — Foreign key → item.item_id — NOT NULL
- reg_time — datetime
- update_time — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- count — int(11)
item
- item_id — long — Primary key — NOT NULL
- reg_time — datetime
- update_time — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- item_detail — tinytext
- item_nm — varchar(50)
- item_sell_status — enum('SELL','SOLD_OUT')
- price — int(11)
- stock_number — int(11)
item_img
- item_img_id — long — Primary key — NOT NULL
- item_id — long — Foreign key → item.item_id — NOT NULL
- reg_time — datetime
- update_time — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- img_name — varchar(255)
- img_url — varchar(255)
- ori_img_name — varchar(255)
- repimg_yn — varchar(255)
member
- member_id — long — Primary key — NOT NULL
- reg_time — datetime
- updae_time (update_time) — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- address — varchar(255)
- email — varchar(255)
- name — varchar(255)
- password — varchar(255)
- role — enum('ADMIN','USER')
order
- order_id — long — Primary key — NOT NULL
- member_id — long — Foreign key → member.member_id — NOT NULL
- reg_time — datetime
- update_time — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- order_date — datetime
- order_status — enum('CANCEL','ORDER')
order_item
- order_item_id — long — Primary key — NOT NULL
- order_id — long — Foreign key → order.order_id — NOT NULL
- item_id (item_id2) — long — Foreign key → item.item_id — NOT NULL
- reg_time — datetime
- update_time — datetime
- created_by — varchar(255)
- modified_by — varchar(255)
- count — int(11)
- order_price — int(11)