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