comapy

Tables (4)

meeting_attendees (회의 참석자)

  • id (식별자) — long — Primary key — NOT NULL
  • member_id (참석자) — long — Foreign key → members.id — NOT NULL
  • meeting_room_reservation_id (회의실 예약) — long — Foreign key → meeting_room_reservation.id — NOT NULL

meeting_room (회의실)

  • id (식별자) — long — Primary key — NOT NULL
  • floor (층) — int
  • name (회의실 이름) — string
  • capacity (최대 수용 인원) — int

meeting_room_reservation (회의실 예약)

  • id (식별자) — long — Primary key — NOT NULL
  • room_id (회의실) — long — Foreign key → meeting_room.id — NOT NULL
  • member_id (예약자) — long — Foreign key → members.id — NOT NULL
  • meeting_name (회의이름) — string
  • start_time (회의시작시간) — time
  • end_time (회의종료시간) — time

members (회사원)

  • id (식별자) — long — Primary key — NOT NULL
  • name (이름) — string
  • mobile (휴대폰번호) — string
  • level (직급) — string