adasdasd

Tables (7)

AS

  • ASID (as_id) — PK — Primary key — NOT NULL
  • 고객ID (customer_id) — Foreign key → Customer.고객ID — NOT NULL

BID (입찰)

    Company (수주업체)

    • 발주ID (bid_id) — PK — Foreign key → Order.발주ID — NOT NULL

    Customer (발주업체)

    • 고객ID (customer_id) — PK — Primary key — NOT NULL

    Order (발주등록)

    • 발주ID (bid_id) — PK — Primary key — NOT NULL
    • 고객ID (customer_id) — Foreign key → Customer.고객ID — NOT NULL
    • 수량 (amount) — 발주 수량
    • 유형 (type) — 발주 유형
    • 메모 (memo) — 용도, 필요성 등
    • Field

    Order_file (발주 파일)

      Review (후기)

      • 리뷰ID (review_id) — PK — Primary key — NOT NULL
      • 고객ID (customer_id) — Foreign key → Customer.고객ID — NOT NULL