1002tech
Tables (3)
Company (회사)
- company_id (Key) — uuid — Primary key — NOT NULL
- company_name (Field) — varchar
- contact_name (Field2) — varchar
- contact_phone (Field3) — int
- contact_email (Field4) — varchar
Product (물건)
- product_id (Key) — uuid — Primary key — NOT NULL
- company_id (Key2) — uuid — Foreign key → Company.company_id — NOT NULL
- product_name (Field) — varchar
- product_quantity (Field2) — varchar
- product_received_date (Field3) — timestamp
- product_expected_out_date (Field4) — timestamp
- product_out_date (Field5) — timestamp
- product_contract_amount (Field6) — int
Untitled3 (대금)
- Key — uuid — Primary key — NOT NULL
- company_id (Key2) — uuid — Foreign key → Company.company_id — NOT NULL
- product_id (Key3) — uuid — Foreign key → Product.product_id — NOT NULL
- company_id (Key22) — uuid — Foreign key → Product.company_id — NOT NULL
- expected_in_date (Field) — timestamp
- actual_in_date (Field2) — timestamp
- payment_received (Field3) — boolean
- Field4