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