미론 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)