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)