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)