order
Tables (5)
buyer (CopyOfCopyOfUntitled)
- 구매자ID (buyer_id) — BIGINT — Primary key — NOT NULL
- 구매자명 (seller_name) — varchar(255) — NOT NULL
- 생성시간 (update_time) — datetime — NOT NULL
- 구매시간 (buy_time) — datetime — NOT NULL
last_order_product (CopyOfUntitled3)
- 총주문id (total_order_id) — Primary key — NOT NULL — auto increment
- 상품id (product_id) — BIGINT — Foreign key → product.상품id — NOT NULL
- 구매자ID (buyer_id2) — BIGINT — Foreign key → order_page.구매자ID — NOT NULL
- 주문_id (order_page) — BIGINT — NOT NULL
- 생성시간 (update_time) — datetime — NOT NULL — default current_timestamp
- 주문수량 (last_quantity) — BIGINT
order_page (CopyOfUntitled2)
- 주문_ID (order_id) — BIGINT — Primary key — NOT NULL
- 구매자ID (buyer_id2) — BIGINT — Foreign key → buyer.구매자ID — NOT NULL
- 주문번호 (order_num) — varchar(255) — NOT NULL
- 구매자id (buyer_id) — BIGINT — NOT NULL
- 생성시간 (update_time) — datetime — NOT NULL
product (Untitled)
- 상품id (product_id) — BIGINT — Primary key — NOT NULL
- 판매자id (seller_id) — BIGINT — Foreign key → seller.판매자id — NOT NULL
- 상품이름 (product_name) — varchar(255) — NOT NULL
- 재고 (quantity) — int — NOT NULL
- 판매자명 (seller_name) — bigint — NOT NULL
- 내용 (content) — varchar(255) — NOT NULL
- 생성시간 (update_time) — datetime — NOT NULL
seller (CopyOfUntitled)
- 판매자id (seller_id) — BIGINT — Primary key — NOT NULL
- 판매자명 (seller_name) — varchar(255) — NOT NULL
- 생성시간 (update_time) — datetime — NOT NULL
- 판매시간 (sell_time) — datetime — NOT NULL