https://www.stayfolio.com/findstay/almagest/room?room_id=1754&identifier=almagest&check_in=&check_out=

table users {

  id int [pk, increment]

  email varchar(50)

  name varchar(50)

  password varchar(200)

  phone varchar(50)

  created_at timestamp

  updated_at timestamp

}

table accomodation {

  id int [pk, increment]

  name varchar(50)

  content varchar(3000)

  location varchar(100)

  stay_type varchar(50)

  theme varchar(50)

  promotion boolean

  promotion_start timestamp

  promotion_end timestamp

  created_at timestamp

  updated_at timestamp

}

table accomodation_images {

  id int [pk, increment]

  accomodation_id int

  image_url varchar(100)

  created_at timestamp

}

table event{

  id int [pk, increment]

  accomodation_id int

  event_detail_emage_url varchar(100)

  event_start timestamp

  event_end timestamp

  created_at timestamp

  updated_at timestamp

}

// if you remain time make event

table room {

  id int [pk, increment]

  accomodation_id int

  name varchar(50)

  // varchar & text is different on efficiency

  // big data varchar = text

  content text

  price int

  max_guest int

  size float

  check_in_time varchar(50)

  check_out_time varchar(50)

  // Many to Many Table revise

  // Make Table not String[].

  // This is noSQL

  features String[]

  amenities String[]

  // survey NoSQL like this.

  // Questionaries can be changed, Question - answer // flex (frequently change), key change easy.

  // Not NoSQL -> RDB (not frequently changed data)

  // Many to Many Table revise

  created_at timestamp

  updated_at timestamp 

}

table room_images {

  id int [pk, increment]

  room_id int

  image_url varchar(100)

  created_at timestamp

}

table reservation {

  id int [pk, increment]

  room_id int

  user_id int

  reservation_start timestamp

  reservation_end timestamp

  price int

  guest int

  special_requests varchar(200)

  created_at timestamp

  updated_at timestamp

}

// Ref: "users"."id" < "posts"."writerId"

// Ref: "users"."id" < "comments"."writerId"

// Ref: "users"."id" < "posting_user_like"."user_id"

// Ref: "posts"."id" < "posting_user_like"."posting_id"

// Ref: "posts"."id" < "comments"."posting_id"

// Ref: "users"."created_at" < "posts"."updated_at"

Ref: "accomodation"."id" < "accomodation_images"."accomodation_id"

Ref: "accomodation"."id" < "room"."accomodation_id"

Ref: "room"."id" < "room_images"."room_id"

Ref: "room"."id" < "reservation"."room_id"

Ref: "users"."id" < "reservation"."user_id"

Ref: "accomodation"."id" < "event"."accomodation_id"