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