our-meeting

테이블 (8)

meeting_room

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — VARCHAR — NOT NULL
  • 위치 (location) — VARCHAR — NOT NULL
  • 수용인원 (capacity) — INT — NOT NULL

meeting

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_room_id — BIGINT — 외래 키 → meeting_room.id — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — VARCHAR — NOT NULL
  • meeting_type — VARCHAR(20) — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL

meeting_room_image

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_room_id — BIGINT — 외래 키 → meeting_room.id — NOT NULL
  • origin_name — VARCHAR — NOT NULL
  • stored_name — VARCHAR — NOT NULL
  • ext — VARCHAR(10) — NOT NULL

이용자 (member)

  • id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → 팀.id
  • username — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • name — VARCHAR — NOT NULL
  • created_date — DATETIME — NOT NULL
  • last_modified_date — DATETIME — NOT NULL
  • created_by — VARCHAR — NOT NULL
  • last_modified_by — VARCHAR — NOT NULL
  • use_yn — CHAR(1) — NOT NULL

참여멤버 (member_meeting)

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → 이용자.id — NOT NULL
  • meeting_id (meeting_id2) — BIGINT — 외래 키 → meeting.id — NOT NULL

팀 (team)

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL

회의실 기자재 (meeting_room_equipment)

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_room_id — BIGINT — 외래 키 → meeting_room.id — NOT NULL
  • equipment — VARCHAR(20) — NOT NULL
  • count — INT — NOT NULL

회의실 즐겨찾기 (member_meeting_room)

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → 이용자.id — NOT NULL
  • meeting_room_id (meeting_room_id2) — BIGINT — 외래 키 → meeting_room.id — NOT NULL