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