ㅇㅇ
Tables (6)
cart
- cartId — int(11) — Primary key — NOT NULL
- userId — varchar(20) — Foreign key → member.id — NOT NULL
- productId — int(11) — Foreign key → product.pid — NOT NULL
- cart_qty — int(11)
- reg_date — timestamp — NOT NULL
image
- pid — int(11) — Foreign key → product.pid
- i_file_name — varchar(512) — NOT NULL
- i_original_name — varchar(512) — NOT NULL
- i_thumbnail_name — varchar(512)
- i_file_type — varchar(128) — NOT NULL
member
- id — varchar(20) — Primary key — NOT NULL
- name — varchar(10) — NOT NULL
- password — varchar(30) — NOT NULL
- phone — varchar(30) — NOT NULL
- gender — varchar(2) — NOT NULL
- join_date — timestamp — NOT NULL
- role — varchar(5) — NOT NULL
- email — varchar(60) — NOT NULL
order_item
- orderItemId — int(11) — Primary key — NOT NULL
- orderId — varchar(50) — Foreign key → order_list.orderId
- pid — int(11) — Foreign key → product.pid
- amount — int(11) — NOT NULL
- price — int(11) — NOT NULL
order_list
- orderId — varchar(50) — Primary key — NOT NULL
- state — varchar(50) — NOT NULL
- userId — varchar(20) — Foreign key → member.id — NOT NULL
- orderDate — timestamp — NOT NULL
product
- pid — int(11) — Primary key — NOT NULL
- pname — varchar(50) — NOT NULL
- pprice — int(11) — NOT NULL
- pcategory — varchar(30) — NOT NULL
- description — varchar(300)
- stock — int(11) — NOT NULL
- reg_date — timestamp — NOT NULL