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 (창고 주소)