order_system
Tables (5)
DELIVER_STATUS (배송상태)
- id (배송상태ID) — BIGINT — Primary key — NOT NULL
- order_id (주문ID) — BIGINT — Foreign key → ORDER.id — NOT NULL
- status (배송상태) — ENUM('배송 전', '배송시작', '배송중','배송완료')
- current_location (현재위치) — VARCHAR(255)
- tracking_number (운송장번호) — VARCHAR(255) — NOT NULL
ORDER (주문내역)
- id (주문ID) — BIGINT — Primary key — NOT NULL
- customer_id (구매자ID) — BIGINT — Foreign key → USER.id — NOT NULL
- date (구매일자) — DATE_FORMAT
ORDER_ITEM (주문상세)
- id (주문상세ID) — BIGINT — Primary key — NOT NULL
- order_id (주문ID) — BIGINT — Foreign key → ORDER.id — NOT NULL
- product_id (상품ID) — BIGINT — Foreign key → PRODUCT.seller_id — NOT NULL
- amount (주문량) — BIGINT — NOT NULL
- purchased_price (구매가격) — BIGINT — NOT NULL
PRODUCT (상품)
- id (상품ID) — BIGINT — Primary key — NOT NULL
- seller_id (판매자ID) — BIGINT — Foreign key → USER.id — NOT NULL
- name (상품이름) — VARCHAR(255) — NOT NULL
- quantity (재고) — BIGINT — NOT NULL
- price (가격) — BIGINT — NOT NULL
USER (회원정보)
- id (회원ID) — BIGINT — Primary key — NOT NULL
- name (회원이름) — VARCHAR(255) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- role (역할) — ENUM(seller, customer)
- address (주소) — VARCHAR(255) — NOT NULL