adasdasd
Tables (7)
AS
- ASID (as_id) — PK — Primary key — NOT NULL
- 고객ID (customer_id) — Foreign key → Customer.고객ID — NOT NULL
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
Review (후기)
- 리뷰ID (review_id) — PK — Primary key — NOT NULL
- 고객ID (customer_id) — Foreign key → Customer.고객ID — NOT NULL