BANDLINK

Tables (6)

Performance

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • description (Field2) — varchar(100)
  • start_time (Field3) — date
  • end_time (Field4) — date
  • price (Field5) — int
  • userId (Key2) — int — Foreign key → User.id — NOT NULL
  • roomId (Key3) — int — Foreign key → Room.id — NOT NULL

Performance Reservation

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key3) — int — Foreign key → User.id — NOT NULL
  • performanceId (Key2) — int — Foreign key → Performance.id — NOT NULL
  • reserved_at (Field4) — date

Place

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • address (Field2) — varchar(100)
  • type (Field3) — varchar(5)
  • business_registration_number (Field5) — varchar(100)
  • userId (Key2) — int — Foreign key → User.id — NOT NULL

Room

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • price (Field2) — int
  • placeId (Key2) — int — Foreign key → Place.id — NOT NULL

Room Reservation

  • id (Key) — int — Primary key — NOT NULL
  • startTime (Field) — date
  • endTime (Field2) — date
  • userId (Key2) — int — Foreign key → User.id — NOT NULL
  • roomId (Key3) — int — Foreign key → Room.id — NOT NULL

User

  • id (Key) — int — Primary key — NOT NULL
  • nickname (Field) — varchar(20)
  • email (Field2) — varchar(100)
  • role (Field3)
  • bandName (Field4) — varchar(40)