LMRS
Tables (4)
member (사용자)
- member_id (PK) — Primary key — NOT NULL
- member_name (Field)
place (사업장)
- place_id (PK) — Primary key — NOT NULL
- place_name (Field2)
- creator (Field3)
- changer (Field6)
- created_at (Field4)
- updated_at (Field5)
reservation (예약)
- reservation_id (Key) — Primary key — NOT NULL
- member_id (PK) — Foreign key → member.member_id — NOT NULL
- room_id (PK2) — Foreign key → room.room_id — NOT NULL
- place_id (FK) — Foreign key → room.place_id — NOT NULL
- start_time (Field)
- end_time (Field2)
- status (Field3)
- created_at (Field4)
- updated_at (Field5)
- requester (Field6)
room (회의실)
- room_id (PK) — Primary key — NOT NULL
- place_id (FK) — Foreign key → place.place_id — NOT NULL
- room_name (Field)
- is_active (Field3)