First come
Tables (6)
order_items (Untitled5)
- orderit_id (주문 항목 id) — Primary key — NOT NULL
- product_id (제품id) — Foreign key → products.product_id — NOT NULL
- order_id (주문id) — Foreign key → orders.order_id — NOT NULL
- user_id (유저id) — Foreign key → orders.user_id — NOT NULL
- Field
orders (Untitled4)
- order_id (주문id) — Primary key — NOT NULL
- user_id (유저id) — Foreign key → user.user_id — NOT NULL
- order_date (주문날짜) — timestamp
- status (주문상태)
- total_amount (총 금액)
products (Untitled2)
- product_id (제품id) — Primary key — NOT NULL
- name (제품이름) — varchar
- description (설명) — text
- price (가격) — var
- stock_quantity (재고량) — var
- created_at (등록일자) — timestamp
- updated_at (수정일자) — timestamp
returns (Untitled6)
- returns_id (반품id) — Primary key — NOT NULL
- orderit_id (주문 항목 id) — Foreign key → order_items.orderit_id — NOT NULL
- return_date (반품시간)
- status (반품상태)
user (Untitled)
- user_id (유저id) — Primary key — NOT NULL
- name (이름)
- phone_number (핸드폰번호) — varchar(11)
- address (주소) — text
- email (이메일) — varchar(255_)
- password (비밀번호)
- created_at (등록일자) — timestamp
- updated_at (수정일자) — timestamp
wishlist (Untitled3)
- wishlsit_id (위시리스트id) — Primary key — NOT NULL
- user_id — Foreign key → user.user_id — NOT NULL
- product_id (제품id) — Foreign key → products.product_id — NOT NULL