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