kh17-final 통합본 백업

테이블 (22)

Attach (Untitled10)

  • attach_no (Key) — 기본 키 — NOT NULL
  • attach_name (Field)
  • attach_type (Field2)
  • attach_size (Field3)

Chat_channel (Untitled14)

  • chat_channel_no (Key) — 기본 키 — NOT NULL
  • project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
  • chat_channel_creator (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • chat_channel_name (Field)
  • chat_channel_ctime (Field2)
  • chat_channel_utime (Field3)

Dept (Untitled6)

  • dept_no (Key) — 기본 키 — NOT NULL
  • dept_name (Field)
  • dept_block (Field2)
  • dept_info (Field3)
  • dept_ctime (Field4)
  • dept_utime (Field5)

Emp (Untitled4)

  • emp_no (Key) — 기본 키 — NOT NULL
  • emp_email (Field)
  • emp_password (Field2)
  • emp_name (Field3)
  • dept_no (Key2) — 외래 키 → Dept.dept_no — NOT NULL
  • position_no (Key3) — 외래 키 → Position.position_no — NOT NULL
  • emp_level (Field5)
  • emp_state (Field4)
  • emp_presence (Field6)
  • emp_birth (Field7)
  • emp_contact (Field8)
  • emp_post (Field9)
  • emp_address1 (Field10)
  • emp_address2 (Field11)
  • emp_ctime (Field12)
  • emp_utime (Field13)

Note (Untitled18)

  • note_no (Key) — 기본 키 — NOT NULL
  • project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
  • note_writer_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • note_title (Field)
  • note_content (Field2)
  • note_ctime (Field3)
  • note_utime (Field4)

Note_file (Untitled19)

  • attach_no (Key2) — 외래 키 → Attach.attach_no — NOT NULL
  • note_no (Key) — 외래 키 → Note.note_no — NOT NULL

Notification (Untitled21)

  • notification_no (Key) — 기본 키 — NOT NULL
  • notification_receiver (Key2) — 외래 키 → Emp.emp_no — NOT NULL
  • project_no (Key3) — 외래 키 → Project.project_no — NOT NULL
  • notification_type (Field)
  • notification_target (Field2)
  • notification_url (Field3)
  • notification_content (Field4)
  • notification_read (Field5)
  • notification_ctime (Field6)
  • notification_rtime (Field7)

Position (Untitled7)

  • position_no (Key) — 기본 키 — NOT NULL
  • position_name (Field)
  • position_block (Field2)
  • position_ctime (Field3)
  • position_utime (Field4)

Project (Untitled)

  • project_no (Key) — 기본 키 — NOT NULL
  • project_name (Field)
  • project_purpose (Field8)
  • project_visibility (Field2)
  • project_status (Field3)
  • project_start (Field4)
  • project_deadline (Field5)
  • project_ctime (Field6)
  • project_utime (Field7)

Project_close (Untitled5)

  • project_no (Key) — 외래 키 → Project.project_no — NOT NULL
  • close_summary (Field)
  • close_good (Field2)
  • close_bad (Field3)
  • close_improvement (Field4)
  • close_ctime (Field5)
  • close_utime (Field6)

Project_expected_result (Untitled2)

  • project_result_no (Key) — 기본 키 — NOT NULL
  • project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
  • project_result_content (Field)
  • project_result_status (Field2)
  • project_result_order (Field3)
  • project_result_ctime (Field4)
  • project_result_utime (Field5)

Project_member (Untitled3)

  • project_member_no (Key3) — 기본 키 — NOT NULL
  • project_role (Field)
  • project_job (Field2)
  • member_ctime (Field3)
  • project_no (Key) — 외래 키 → Project.project_no — NOT NULL
  • emp_no (Key2) — 외래 키 → Emp.emp_no — NOT NULL

Schedule (Untitled17)

  • schedule_no (Key) — 기본 키 — NOT NULL
  • project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
  • schedule_writer_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • schedule_title (Field)
  • schedule_content (Field2)
  • schedule_start (Field3)
  • schedule_end (Field4)
  • schedule_place (Field5)
  • schedule_ctime (Field6)
  • schedule_utime (Field7)

Task (Untitled8)

  • task_no (Key) — 기본 키 — NOT NULL
  • project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
  • task_title (Field)
  • task_content (Field2)
  • assigned_member_no (Key32) — 외래 키 → Project_member.project_member_no — NOT NULL
  • task_status (Field3)
  • task_start (Field4)
  • task_end (Field5)
  • task_category (Field6)
  • task_priority (Field8)
  • task_progress (Field9)
  • task_writer_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • task_ctime (Field10)
  • Field11

Task_collaborator (Untitled9)

  • task_no (Key) — 외래 키 → Task.task_no — NOT NULL
  • project_member_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • task_collaborator_ctime (Field)

Task_file (Untitled11)

  • attach_no (Key2) — 외래 키 → Attach.attach_no — NOT NULL
  • task_no (Key) — 외래 키 → Task.task_no — NOT NULL

chat_message (Untitled15)

  • chat_message_no (Key) — 기본 키 — NOT NULL
  • chat_channel_no (Key2) — 외래 키 → Chat_channel.chat_channel_no — NOT NULL
  • chat_message_sender (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • chat_message_content (Field)
  • chat_message_type (Field3)
  • chat_message_ctime (Field2)

chat_read (Untitled22)

  • chat_message_no (Key) — 외래 키 → chat_message.chat_message_no — NOT NULL
  • project_member_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • chat_read_status (Field)

emp_profile (Untitled12)

  • emp_no (Key) — 외래 키 → Emp.emp_no — NOT NULL
  • attach_no (Key2) — 외래 키 → Attach.attach_no — NOT NULL

message_file (Untitled16)

  • chat_message_no (Key) — 외래 키 → chat_message.chat_message_no — NOT NULL
  • attach_no (Key2) — 외래 키 → Attach.attach_no — NOT NULL

note_comment (Untitled20)

  • note_comment_no (Key) — 기본 키 — NOT NULL
  • note_no (Key2) — 외래 키 → Note.note_no — NOT NULL
  • project_member_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • note_comment_content (Field)
  • note_comment_ctime (Field2)
  • note_comment_utime (Field3)

task_comment (Untitled13)

  • task_comment_no (Key2) — 기본 키 — NOT NULL
  • task_no (Key) — 외래 키 → Task.task_no — NOT NULL
  • project_member_no (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
  • task_comment_content (Field)
  • task_comment_ctime (Field2)
  • task_comment_utime (Field3)