test

Tables (15)

after_service_comments

  • id — unsignedbigint — Primary key — NOT NULL
  • comment — varchar(255) — NOT NULL
  • after_service_id — unsignedbigint — NOT NULL

after_service_images

  • id — unsignedbigint — Primary key — NOT NULL
  • as_id — unsignedbigint — NOT NULL
  • image — varchar(255) — NOT NULL

after_services

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • status — char(1) — NOT NULL
  • visit_date — timestamp

bus_times

  • id — unsignedbigint — Primary key — NOT NULL
  • bokhyun — time — NOT NULL
  • woobang — time — NOT NULL
  • city — time — NOT NULL
  • sk — time — NOT NULL
  • dc — time — NOT NULL
  • bukgu — time — NOT NULL
  • bank — time — NOT NULL
  • taejeon — time — NOT NULL
  • g_domitory — time — NOT NULL
  • g_campus — time — NOT NULL
  • en — time — NOT NULL
  • munyang — time — NOT NULL
  • start_end — boolean — NOT NULL
  • week_end — boolean — NOT NULL

meeting_room_

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • meeting_room_id — unsignedbigint — NOT NULL
  • status — char(1) — NOT NULL
  • reservation_date — timestamp — NOT NULL

meeting_rooms

  • id — unsignedbigint — Primary key — NOT NULL
  • room_number — char(3) — NOT NULL

notice_images

  • id — unsignedbigint — Primary key — NOT NULL
  • notice_id — unsignedbigint — NOT NULL
  • image — varchar(255) — NOT NULL

notices

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • tag — varchar(10) — NOT NULL

restaurant_menus

  • id — unsignedbigint — Primary key — NOT NULL
  • restaurant_menu — 미정 — NOT NULL

restaurant_semesters

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • menu_type — char(1) — NOT NULL
  • payment — boolean — NOT NULL

restaurant_weekend

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • sat — boolean — NOT NULL
  • sun — boolean — NOT NULL

salon_menus

  • id — unsignedbigint — Primary key — NOT NULL
  • service — varchar(15) — NOT NULL
  • price — unsignedmediumint — NOT NULL

salon_reservations

  • id — unsignedbigint — Primary key — NOT NULL
  • salon_menu_id — unsignedbigint — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • reservation_date — timestamp — NOT NULL
  • status — char(1) — NOT NULL

sleepover_lists

  • id — unsignedbigint — Primary key — NOT NULL
  • user_id — unsignedbigint — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • status — char(1) — NOT NULL
  • content — varchar(255) — NOT NULL

users

  • id — unsignedbigint — Primary key — NOT NULL
  • student_id — char(7) — NOT NULL
  • password — varchar(255) — NOT NULL
  • manager — boolean — NOT NULL