dismiss
Tables (7)
cart (장바구니)
- cart_id (Key) — int — Primary key — NOT NULL
- total_price (Field) — int
- customer_id (Key2) — int — Foreign key → customer.customer_id — NOT NULL
cart_item (장바구니상품)
- cart_id (Key) — int — Foreign key → cart.cart_id — NOT NULL
- item_id (Key2) — int — Foreign key → item.item_id — NOT NULL
customer (고객)
- customer_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(255)
- address (Field2) — varchar(255)
- tel (Field3) — varchar(255)
- coupon_count (Field4) — int
item (상품)
- item_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar(255)
- type (Field2) — varchar(255)
- price (Field3) — int
- score (Field4) — float
- amount (Field5) — int
order_item (주문상품)
- item_id (Key) — int — Foreign key → item.item_id — NOT NULL
- order_id (Key2) — int — Foreign key → orders.order_id — NOT NULL
orders (주문)
- order_id (Key) — int — Primary key — NOT NULL
- deliverycondition (Field) — int
- pucharse_date (Field2) — DATE
- customer_id (Key2) — int — Foreign key → customer.customer_id — NOT NULL
review (리뷰)
- customer_id (Key) — int — Foreign key → customer.customer_id — NOT NULL
- item_id (Key2) — int — Foreign key → item.item_id — NOT NULL
- score (Field) — int
- comments (Field2) — varchar(255)