bid-data

Tables (9)

Customer (customer)

  • customer_id (고객 식별번호) — Primary key — NOT NULL
  • customer_name (고객 이름)
  • customer_address (고객 주소)
  • customer_contact (고객 연락처)

District (district)

  • district_id (구역 식별번호) — Primary key — NOT NULL
  • district_name (구역 이름)
  • district_address (구역 주소)
  • warehouse_id (창고 식별번호) — Foreign key → Warehouse.warehouse_id — NOT NULL
  • customer_id (고객 식별번호) — Foreign key → Customer.customer_id — NOT NULL

History (history)

  • history_id (기록 식별번호) — Primary key — NOT NULL
  • history_amount (기록 수량)
  • district_id (구역 식별번호) — Foreign key → District.district_id — NOT NULL
  • customer_id (고객 식별번호) — Foreign key → Customer.customer_id — NOT NULL

Item (item)

  • item_id (아이템 식별번호) — LONG — Primary key — NOT NULL
  • item_name (아이템 상품명) — NOT NULL
  • item_price (아이템 가격) — NOT NULL
  • item_data (상세 정보)

NewOrder (new_order)

  • new_order_id (새 주문 식별번호) — Primary key — NOT NULL
  • order_id (주문 식별번호2) — Foreign key → Order.order_id — NOT NULL

Order (order)

  • order_id (주문 식별번호) — Primary key — NOT NULL
  • order_entry (주문 명단)
  • customer_id (고객 식별번호) — Foreign key → Customer.customer_id — NOT NULL

OrderLine (order_line)

  • order_line_id (주문 상품 식별번호) — Primary key — NOT NULL
  • order_line_qunatity (주문 상품 수량)
  • item_id (아이템 식별번호) — LONG — Foreign key → Item.item_id — NOT NULL
  • order_id (주문 식별번호) — Foreign key → Order.order_id — NOT NULL

Stock (stock)

  • stock_id (재고 식별번호) — Primary key — NOT NULL
  • stock_quantity (재고 수량)
  • stock_order_count (재고 주문 수량)
  • item_id (아이템 식별번호) — LONG — Foreign key → Item.item_id — NOT NULL
  • warehouse_id (창고 식별번호) — Foreign key → Warehouse.warehouse_id — NOT NULL

Warehouse (warehouse)

  • warehouse_id (창고 식별번호) — Primary key — NOT NULL
  • warehouse_name (창고 이름)
  • warehouse_address (창고 주소)