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