example
Tables (9)
ASSIGN
- task_no — varchar
- project_no — varchar — Foreign key → PROJECT.project_no
- emp_no — varchar — Foreign key → EMPLOYEE.emp_no
- task_name — varchar
- priority — varchar
CLIENT
- business_no — varchar
- company_name — varchar
- ceo_name — varchar
EMPLOYEE
- emp_no — varchar
- emp_name — varchar
FILE_ATTACHMENT
- file_id — varchar
- file_post_id — varchar — Foreign key → FILE_POST.file_post_id
- file_path — varchar
- upload_date — datetime
FILE_POST
- file_post_id — varchar
- project_no — varchar — Foreign key → PROJECT.project_no
- emp_no — varchar — Foreign key → EMPLOYEE.emp_no
- content — text
- created_at — datetime
ISSUE_POST
- issue_post_id — varchar
- project_no — varchar — Foreign key → PROJECT.project_no
- emp_no — varchar — Foreign key → EMPLOYEE.emp_no
- content — text
- parent_comment_id — varchar — Foreign key → ISSUE_POST.issue_post_id
- created_at — datetime
MEMBER
- task_no — varchar
- project_no — varchar — Foreign key → PROJECT.project_no
- emp_no — varchar — Foreign key → EMPLOYEE.emp_no
- task_name — varchar
- priority — varchar
PROJECT
- project_no — varchar
- project_name — varchar
- team_no — varchar
- business_no — varchar — Foreign key → CLIENT.business_no
- start_date — date
- end_date — date
- status — varchar
- priority — varchar
- importance — varchar
USER_LOG
- log_id — varchar
- emp_no — varchar — Foreign key → EMPLOYEE.emp_no
- event_type — varchar
- event_time — datetime
- related_id — varchar