123

Tables (18)

admin

  • idx — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(20)
  • name — varchar(30) — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • status — tinyint — NOT NULL
  • last_connection — datetime — NOT NULL
  • phone_number — varchar(20)

board_like

  • idx — bigint — Primary key — NOT NULL
  • user_idx — bigint — NOT NULL
  • board_idx — bigint — NOT NULL

bookmark

  • idx — bigint — Primary key — NOT NULL
  • board_idx — bigint — NOT NULL
  • user_idx — bigint — NOT NULL

calendar

  • idx — int — Primary key — NOT NULL
  • plan_idx — bigint — NOT NULL

category

  • idx — varchar(20) — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL

chatting_room

  • idx — bigint — Primary key — NOT NULL
  • response_idx — bigint — NOT NULL
  • request_idx — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • status — tinyint — NOT NULL

comment

  • idx — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • board_idx — bigint — NOT NULL
  • user_idx — bigint — NOT NULL

comment_like

  • idx — bigint — Primary key — NOT NULL
  • user_idx — bigint — NOT NULL
  • comment_idx — bigint — NOT NULL

community_board

  • idx — bigint — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • content — text — NOT NULL
  • image — varchar(200)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • user_idx — bigint — NOT NULL
  • category — varchar(20) — NOT NULL

joongna_board

  • idx — bigint — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • content — text — NOT NULL
  • image — varchar(200) — NOT NULL
  • created_at — datetime — NOT NULL
  • update_at — datetime — NOT NULL
  • status — tinyint — NOT NULL
  • price — int — NOT NULL
  • user_idx — bigint — NOT NULL

messages

  • idx — bigint — Primary key — NOT NULL
  • sendtime — datetime — NOT NULL
  • content — text — NOT NULL
  • chatting_room_idx — bigint — NOT NULL
  • sender_idx — bigint — NOT NULL

plan

  • idx — bigint — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • contents — text — NOT NULL
  • start_date — date — NOT NULL
  • course_num — int — NOT NULL
  • end_date — date — NOT NULL

project

  • idx — bigint — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • video — varchar(200)
  • contents — text — NOT NULL
  • course_num — int — NOT NULL
  • team_name — varchar(30) — NOT NULL
  • member — varchar(100) — NOT NULL

recomment

  • idx — bigint — Primary key — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • comment_idx — bigint — NOT NULL
  • user_idx — bigint — NOT NULL

recomment_like

  • idx — bigint — Primary key — NOT NULL
  • recomment_idx — bigint — NOT NULL
  • user_idx — bigint — NOT NULL

reservation

  • idx — bigint — Primary key — NOT NULL
  • num_of_mem — int — NOT NULL
  • reserve_date — datetime — NOT NULL
  • table_num — int — NOT NULL
  • created_at — datetime — NOT NULL
  • reserve_mem_id — bigint — NOT NULL
  • status — tinyint — NOT NULL

seat

  • idx — bigint — Primary key — NOT NULL
  • seat_num — int — NOT NULL
  • floor — int — NOT NULL
  • reservation_idx — bigint — NOT NULL
  • status — tinyint — NOT NULL

user

  • idx — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(20)
  • name — varchar(30) — NOT NULL
  • nickname — varchar(10) — NOT NULL
  • role — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • phone_number — varchar(20) — NOT NULL
  • address — varchar(100)
  • socialLogined — tinyint — NOT NULL
  • access_token — varchar(255)
  • refresh_token — varchar(255)
  • course_num — int — NOT NULL
  • status — tinyint — NOT NULL