shoping_erd
Tables (6)
cart
- 장바구니ID (carrier_id) — BIGINT — Primary key — NOT NULL
- 회원ID (user_id) — BIGINT — Primary key — NOT NULL
- 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
- 장바구니 수량 (item_id) — BIGINT — NOT NULL
order_items
- 주문내역ID (order_etc) — BIGINT — Primary key — NOT NULL
- 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
- 주문ID (order_id) — BIGINT — Primary key — NOT NULL
- 주문수량 (order_num) — BIGINT — NOT NULL
orders
- 주문ID (order_id) — BIGINT — Primary key — NOT NULL
- 회원ID (user_id) — BIGINT — Primary key — NOT NULL
- 주문시간 (order_time) — DATETIME — NOT NULL
product_options
- 상품옵션ID (item_opt) — BIGINT — Primary key — NOT NULL
- 상품ID (item_id) — BIGINT — Primary key — NOT NULL
- 옵션 재고 (item_num) — BIGINT
- 가격 (item_price) — BIGINT — NOT NULL
products
- 상품ID (item_id) — BIGINT — Primary key — NOT NULL
- 상품명 (item_name) — VARCHAR(255) — NOT NULL
users
- 회원ID (user_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(150) — NOT NULL
- 이메일 (email) — TEXT — NOT NULL
- 패스워드 (passwd) — VARCHAR(255) — NOT NULL
- 주소 (address) — VARCHAR(255)
- 회원유형 (usertype) — ENUM('member','superuser') — NOT NULL