Project Management Tool

Tables (7)

Undefined (USER)

  • Key (USER_ID) — TEXT — Primary key — NOT NULL
  • Field (USER_NAME) — TEXT

Untitled (USER_ROLE)

  • Key (USER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Field (UPDATED_AT) — TIMESTAMP
  • Key (CODE_ID) — TEXT — Foreign key → Untitled.Key — NOT NULL
  • Key (MODIFIER_ID) — INTEGER — Foreign key → Undefined.Key — NOT NULL

Untitled (GROUP_CODE)

  • Key (GROUP_CODE_ID) — TEXT — Primary key — NOT NULL
  • Field (GROUP_CODE_NAME) — TEXT
  • Field (GROUP_CODE_DETAIL) — TEXT
  • Key (WRITER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Key (MODIFIER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (CODE)

  • Key (CODE_ID) — TEXT — Primary key — NOT NULL
  • Field (CODE_NAME) — TEXT
  • Field (CODE_DETAIL) — TEXT
  • Key (GROUP_CODE_ID) — TEXT — Foreign key → Untitled.Key — NOT NULL
  • Key (WRITER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Key (MODIFIER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (PROJECT_COST)

  • Key (PROJECT_COST_ID) — INTEGER — Primary key — NOT NULL
  • Field (PROJECT_NAME) — TEXT
  • Key (PROJECT_MANAGER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Key (TEAM_CODE_ID) — TEXT — Foreign key → Untitled.Key — NOT NULL
  • Field (START_AT) — TEXT
  • Field (END_AT) — TEXT
  • Field (PROJECT_DURATION) — INTEGER
  • Field (TOTAL_SALES) — INTEGER
  • Field (EMPLOYEE_RATE) — NUMERIC
  • Field (FREE_RATE) — NUMERIC
  • Field (TOTAL_COST) — INTEGER
  • Field (PROFIT_RATE) — NUMERIC
  • Field (PROFIT) — INTEGER
  • Field (TOTAL_MONTH) — NUMERIC
  • Field (TOTAL_USER_COST) — INTEGER
  • Key (WRITER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Key (MODIFIER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP
  • Field (UPDATED_AT) — TIMESTAMP

Untitled (USER_COST)

  • Key (USER_COST_ID) — INTEGER — Primary key — NOT NULL
  • Field (TOTAL_MONTH) — NUMERIC
  • Field (COST_BY_MONTH) — INTEGER
  • Field (TOTAL_COST) — INTEGER
  • Key (USER_ID) — TEXT — Foreign key → Undefined.Key — NOT NULL
  • Key (PROJECT_COST_ID) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (WORK_MONTH)

  • Key (WORK_MONTH_ID) — INTEGER — Primary key — NOT NULL
  • Key (USER_COST_ID) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (MONTH) — INTEGER
  • Field (WORK_TIME) — NUMERIC