wb

Tables (13)

Engineer (Untitled)

  • id — Primary key — NOT NULL
  • name
  • joining_date — 지금은 쓰징낳음
  • leaving_date
  • type_id — Foreign key → engineer_type.id — NOT NULL

Untitled5 (reversion)

  • rev — Foreign key → revision.rev — NOT NULL
  • Field2 (reversion_id)

company

  • id — Primary key — NOT NULL
  • name
  • group_id — Foreign key → company_group.id — NOT NULL

company_group

  • id — Primary key — NOT NULL
  • name

contract

  • id — Primary key — NOT NULL
  • company_id — Foreign key → company.id — NOT NULL
  • sales_id — Foreign key → sales.id — NOT NULL
  • self_contracting_id — Foreign key → sales.id — NOT NULL
  • engineer_id — Foreign key → Engineer.id — NOT NULL
  • start_date
  • end_date
  • 延長 (extension) — boolean

contract_termination (Untitled3)

  • id — Primary key — NOT NULL
  • contracte_id (id2) — Foreign key → contract.id — NOT NULL
  • contract_termination_staus (id3) — Foreign key → contract_termination_status.id — NOT NULL

contract_termination_status (Untitled4)

  • id — Primary key — NOT NULL
  • name

engineer_type

  • id — Primary key — NOT NULL
  • name

prospective_engiener (Untitled2)

  • id — auto incurement — Primary key — NOT NULL
  • name
  • joining_date — localdate
  • has_contract — boolean
  • type_id — Foreign key → engineer_type.id — NOT NULL

revision (revision_info)

  • rev — Primary key — NOT NULL
  • revstamp
  • id_address
  • memo

sales

  • id (Key) — Primary key — NOT NULL
  • name
  • status_id — Foreign key → sales_status.id — NOT NULL

sales_status

  • id — Primary key — NOT NULL
  • name

ユーザー (user)

  • id — Primary key — NOT NULL
  • username
  • password
  • role