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