미론 ERD
테이블 (15)
결정사항 (CopyOfCopyOfCopyOfCopyOfUntitled23)
- DECISION_ID (Key) — BIGINT — 기본 키 — NOT NULL
- AGENDA_ID (Key2) — BIGINT — 외래 키 → 아젠다.AGENDA_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CONTENTS (Field3) — VARCHAR(500)
아젠다 (CopyOfCopyOfUntitled2)
- AGENDA_ID (Key) — BIGINT — 기본 키 — NOT NULL
- MEETING_ID (Key2) — BIGINT — 외래 키 → 회의.MEETING_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CONTENTS (Field3) — VARCHAR(500)
아젠다 파일 (CopyOfCopyOfCopyOfUntitled22)
- AGENDA_FILE_ID (Key) — BIGINT — 기본 키 — NOT NULL
- AGENDA_ID (Key2) — BIGINT — 외래 키 → 아젠다.AGENDA_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- EXTENTION_NAME (Field3) — VARCHAR(20)
- FILENAME (Field4) — VARCHAR(200)
- URL (Field5) — VARCHAR(300)
워크스페이스 (WORKSPACE)
- WORKSPACE_ID (Key) — BIGINT — 기본 키 — NOT NULL
- CREATED_DATE (Field2) — TIMESTAMP
- LAST_MODIFIED_DATE (Field3) — TIMESTAMP
- NAME (Field) — VARCHAR(300)
- WORKSPACE_LOGO_URL (Field4) — VARCHAR(300)
워크스페이스 회원 (Untitled)
- WORKSPACE_MEMBER_ID (Key) — BIGINT — 기본 키 — NOT NULL
- WORKSPACE_ID (Key2) — BIGINT — 외래 키 → 워크스페이스.WORKSPACE_ID — NOT NULL
- MEMBER_ID (Key3) — BIGINT — 외래 키 → 회원.MEMBER_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- IS_WORKSPACE_ADMIN (Field3)
이슈 (CopyOfCopyOfCopyOfUntitled2)
- ISSUE_ID (Key) — BIGINT — 기본 키 — NOT NULL
- AGENDA_ID (Key2) — BIGINT — 외래 키 → 아젠다.AGENDA_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CONTENTS (Field3) — VARCHAR(500)
인사이트 (CopyOfCopyOfCopyOfCopyOfUntitled24)
- INSIGHT_ID (Key) — BIGINT — 기본 키 — NOT NULL
- ATTENDEE_ID (Key2) — BIGINT — 외래 키 → 회의 참가자.ATTENDEE_ID — NOT NULL
- MEETING_ID (Key3) — BIGINT — 외래 키 → 회의.MEETING_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CATEGORY (Field4) — VARCHAR(20)
- CONTENTS (Field3) — VARCHAR(500)
체크/질문/제안(리액션) (CopyOfCopyOfCopyOfCopyOfUntitled22)
- REACTION_ID (Key) — BIGINT — 기본 키 — NOT NULL
- AGENDA_ID (Key2) — BIGINT — 외래 키 → 아젠다.AGENDA_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- REACTION_STATUS (Field3) — VARCHAR(50)
- CONTENTS (Field4) — VARCHAR(500)
팀 (CopyOfUntitled2)
- TEAM_ID (Key) — BIGINT — 기본 키 — NOT NULL
- WORKSPACE_ID (Key2) — BIGINT — 외래 키 → 워크스페이스.WORKSPACE_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- NAME (Field3) — VARCHAR(100)
- TEAM_LOGO_URL (Field4) — VARCHAR(200)
팀에 속한 회원 (CopyOfUntitled3)
- TEAM_MEMBER_ID (Key) — BIGINT — 기본 키 — NOT NULL
- TEAM_ID (Key2) — BIGINT — 외래 키 → 팀.TEAM_ID — NOT NULL
- MEMBER_ID (Key3) — BIGINT — 외래 키 → 회원.MEMBER_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- IS_TEAM_ADMIN (Field3)
- Field4
피드백 (CopyOfCopyOfCopyOfCopyOfUntitled2)
- FEEDBACK_ID (Key) — BIGINT — 기본 키 — NOT NULL
- MEETING_ID (Key2) — BIGINT — 외래 키 → 회의.MEETING_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CONTENTS (Field3) — VARCHAR(500)
향후과업 (CopyOfCopyOfCopyOfUntitled23)
- CHALLENGE_ID (Key) — BIGINT — 기본 키 — NOT NULL
- AGENDA_ID (Key2) — BIGINT — 외래 키 → 아젠다.AGENDA_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- CONTENTS (Field3) — VARCHAR(500)
회원 (MEMBER)
- MEMBER_ID (Key) — BIGINT — 기본 키 — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- NAME (Field3) — VARCHAR(30)
- PROFILE_IMAGE_URL (Field4) — VARCHAR(200)
- POSITION (Field5) — VARCHAR(60)
- EMAIL (Field6) — VARCHAR(200)
- PHONE (Field7) — VARCHAR(20)
회의 (CopyOfUntitled)
- MEETING_ID (Key) — BIGINT — 기본 키 — NOT NULL
- TEAM_ID (Key2) — BIGINT — 외래 키 → 팀.TEAM_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- NAME (Field4) — VARCHAR(150)
- PURPOSE (Field3) — VARCHAR(50)
- START_DATE_TIME (Field5) — TIMESTAMP
- END_DATE_TIME (Field6) — TIMESTAMP
- PLACE (Field7) — VARCHAR(200)
- IS_ROUTINE (Field8) — TINYINT(1)
- ROUTINE_TYPE (Field9) — VARCHAR(20)
- ROUTINE_DAY (Field10) — INT
- ROUTINE_DAY_OF_THE_WEEK (Field11) — VARCHAR(20)
회의 참가자 (Untitled2)
- ATTENDEE_ID (Key) — BIGINT — 기본 키 — NOT NULL
- MEETING_ID (Key3) — BIGINT — 외래 키 → 회의.MEETING_ID — NOT NULL
- MEMBER_ID (Key2) — BIGINT — 외래 키 → 회원.MEMBER_ID — NOT NULL
- CREATED_DATE (Field) — TIMESTAMP
- LAST_MODIFIED_DATE (Field2) — TIMESTAMP
- POSITION (Field3) — VARCHAR(50)
- ATTEND_STATE (Field4) — VARCHAR(30)