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)