kh17-final-record관련
테이블 (12)
Attach (Untitled8)
- attach_no (Key) — 기본 키 — NOT NULL
Chat_message (Untitled6)
- chat_message_no (Key) — 기본 키 — NOT NULL
Note (Untitled7)
- note_no (Key) — 기본 키 — NOT NULL
Project (Untitled)
- project_no (Key) — 기본 키 — NOT NULL
Project_member (Untitled3)
- project_member_no (Key) — 기본 키 — NOT NULL
Project_record (Untitled2)
- project_record_no (Key) — 기본 키 — NOT NULL
- project_no (Key2) — 외래 키 → Project.project_no — NOT NULL
- project_record_writer (Key3) — 외래 키 → Project_member.project_member_no — NOT NULL
- project_record_modifier (Key4) — 외래 키 → Project_member.project_member_no — NOT NULL
- project_record_type (Field)
- project_record_title (Field2)
- project_record_content (Field3)
- project_record_ctime (Field4)
- project_record_utime (Field5)
Project_record_attach (Untitled12)
- project_record_no (Key) — 외래 키 → Project_record.project_record_no — NOT NULL
- attach_no (Key2) — 외래 키 → Attach.attach_no — NOT NULL
Project_record_issue (Untitled4)
- project_record_no (Key) — 외래 키 → Project_record.project_record_no — NOT NULL
- project_record_issue_status (Field)
- project_record_issue_resolution (Field2)
- project_record_issue_resolved_at (Field3)
Project_record_message (Untitled11)
- project_record_no (Key) — 외래 키 → Project_record.project_record_no — NOT NULL
- chat_message_no (Key2) — 외래 키 → Chat_message.chat_message_no — NOT NULL
Project_record_note (Untitled10)
- project_record_no (Key) — 외래 키 → Project_record.project_record_no — NOT NULL
- note_no (Key2) — 외래 키 → Note.note_no — NOT NULL
Project_record_task (Untitled9)
- project_record_no (Key) — 외래 키 → Project_record.project_record_no — NOT NULL
- task_no (Key2) — 외래 키 → Task.task_no — NOT NULL
Task (Untitled5)
- task_no (Key) — 기본 키 — NOT NULL