shoppingMall
Tables (6)
cart_items (Untitled5)
- cart_item_id (Key) — Primary key — NOT NULL
- member_id (Field)
- product_id (Field2)
- quentity (Field3)
- total_price (Field4)
members (Untitled)
- 회원고유번호 (member_id) — INT — Primary key — NOT NULL
- 유저 아이디 (user_id) — VARCHAR(30) — NOT NULL
- 비밀번호 (password) — VARCHAR(20) — NOT NULL
- 이름 (name) — VARCHAR(15) — NOT NULL
- 전화번호 (phone_number) — BIGINT — NOT NULL
- 회원등급 (grade) — VARCHAR(20) — NOT NULL
- 가입 날짜 (created_at) — timestamp — NOT NULL
- 탈퇴여부 (is_deleted) — VARCHAR — NOT NULL
order_items (Untitled4)
- order_items_id (Key) — Primary key — NOT NULL
- order_id (Field)
- product_id (Field2)
- quantity (Field3)
- order_price (Field4)
orders (Untitled3)
- order_id (Key) — Primary key — NOT NULL
- order_number (Field)
- member_id (Field2)
- order_date (Field3)
- total_price (Field4)
- status (Field5)
products (Untitled2)
- prodect_id (Key) — Primary key — NOT NULL
- name (Field)
- product_code (Field2)
- price (Field3)
- is_sold_out (Field4)
- created_at (Field5)