라자다쇼핑몰
테이블 (8)
결제 (Untitled4)
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
교환 및 환불 (Untitled7)
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field8
리뷰 (Untitled)
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
배송 (Untitled5)
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
상품 (products)
- product_id (key) — bigint
- seller_id (Field2) — bigint
- category_id (Field3) — bigint
- brand (Field4) — varchar(100)
- title (Field5) — varchar(255)
- url (Field6) — varchar(500)
- description (Field7) — text
- initial_price (Field8) — decimal(12,2)
- final_price (Field9) — decimal(12,2)
- currency (Field10) — varchar(10)
- returns_and_warranty (Field11) — text
- is_lazmall (Field) — boolean
- created_at (Field12) — timestamp
- updated_at (Field13) — timestamp
주문 (orders)
- oreder_id (Key) — bigint — 기본 키 — NOT NULL
- order_number (Field3) — varchar(50)
- order_status (Field4) — varchar(30)
- total_amount (Field5) — decimal(12,2)
- ordered_at (Field6) — timestamp
- created_at (Field7) — timestamp
- updated_at (Field) — timestamp
- user_id (Key2) — bigint — 외래 키 → 회원.user_id — NOT NULL
주문상세 (order_items)
- id (Key) — bigint — 기본 키 — NOT NULL
- product_id (Field5) — bigint
- product_variant_id (Field6) — bigint
- seller_id (Field7) — bigint
- quantity (Field8) — int
- unit_price (Field9) — decimal(12,2)
- discount_amount (Field10) — decimal(12,2)
- final_amount (Field11) — decimal(12,2)
- item_status (Field12) — varchar(30)
- created_at (Field) — timestamp
- updated_at (Field2) — timestamp
- oreder_id (Key2) — bigint — 외래 키 → 주문.oreder_id — NOT NULL
회원 (users)
- user_id (Key) — bigint — 기본 키 — NOT NULL
- email (Field2) — varchar(100)
- password (Field3) — varchar(255)
- name (Field4) — varchar(50)
- phone (Field5) — varchar(30)
- created_at (Field6) — timestamp
- updated_at (Field7) — timestamp