Contract Settlement Management
Tables (7)
Client (Untitled6)
- id (Key) — IntegerField — Primary key — NOT NULL
- company (Field) — CharField
- manager_name (Field5) — CharField
- manager_email (Field2) — EmailField
- manager_phone (Field3) — CharField
- business_registration (Field4) — FileField
Consortium (Untitled7)
- id (Key) — IntegerField — Primary key — NOT NULL
- company (Field) — CharField
- manager_name (Field2) — CharField
- manager_email (Field3) — EmailField
- manager_phone (Field4) — CharField
- account_image (Field5) — FileField
ContractManagement (Untitled4)
- id (Key) — IntegerField — Primary key — NOT NULL
- project (Key2) — ForeignKey — Foreign key → Project.id — NOT NULL
- status (Field) — CharField, Choices
- note (Field3) — TextField
- is_maintenance (Field4) — BooleanField
- is_reoutsourcing (Field5) — BooleanField
Employee (Untitled)
- id (Key) — IntegerField — Primary key — NOT NULL
- team (Key2) — ForeignKey — Foreign key → Team.id — NOT NULL
- name (Field) — CharField
- position_kind (Field2) — CharField, Choices
Project (Untitled3)
- id (Key) — IntegerField — Primary key — NOT NULL
- employee_set (Key2) — ManyToManyField — Foreign key → Employee.id — NOT NULL
- client (Key3) — ForeignKey — Foreign key → Client.id — NOT NULL
- consortium_set (Key4) — ManyToManyField — Foreign key → Consortium.id — NOT NULL
- name (Field) — CharField
- start_date (Field2) — DateField
- end_date (Field3) — DateField
- develop_start_date (Field5) — DateField
- develop_end_date (Field6) — DateField
- contract_amount (Field4) — PositiveIntegerField
- status (Field7) — CharField, Choices
SettlementInformation (Untitled5)
- id (Key2) — IntegerField — Primary key — NOT NULL
- contract_management (Key) — ForeignKey — Foreign key → ContractManagement.id — NOT NULL
- paid_date (Field4) — DateField
- amount (Field) — IntegerField
- payment_kind (Field3) — CharField, Choices
- status (Field2) — CharField, Choices
- maintenance_month (Field5) — CharField, Choices
- delay_date (Field6) — DateField
- delay_reason (Field7) — TextField
Team (Untitled2)
- id (Key) — IntegerField — Primary key — NOT NULL
- name (팀 이름) — CharField