erd

Tables (18)

auth_password_login

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • password — character — NOT NULL

auth_social_login

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • access_token — character — NOT NULL

lightning_board_images

  • id — integer — Primary key — NOT NULL
  • lightning_board_id — integer — Foreign key → lightning_recruitment_boards.lightning_id — NOT NULL
  • img_url — character — NOT NULL
  • img_key — character — NOT NULL

lightning_info

  • id — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • active — integer — NOT NULL
  • meeting_date — date — NOT NULL

lightning_recruitment_boards

  • id — integer — Primary key — NOT NULL
  • lightning_id — integer — Foreign key → lightning_to_user.lightning_id — NOT NULL
  • author — integer — Foreign key → user.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • title — character — NOT NULL
  • contents — text

lightning_to_user

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • lightning_id — integer — Foreign key → lightning_info.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • is_accept — integer — NOT NULL
  • is_admin — integer — NOT NULL

study

  • id — integer — Primary key — NOT NULL
  • active — boolean — NOT NULL
  • end_date — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

study_admins

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • study_id — integer — Foreign key → study.id — NOT NULL

study_board

  • id — integer — Primary key — NOT NULL
  • study_id — integer — Foreign key → study.id — NOT NULL
  • writer_id — integer — Foreign key → user.id — NOT NULL
  • title — character — NOT NULL
  • content — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

study_board_img

  • id — integer — Primary key — NOT NULL
  • study_board_id — integer — Foreign key → study_board.id — NOT NULL
  • imgUrl — character — NOT NULL
  • imgKey — character — NOT NULL

study_calendar

  • id — integer — Primary key — NOT NULL
  • study_id (id2) — integer — Foreign key → study.id — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • date — timestamp — NOT NULL
  • content — character — NOT NULL

study_recruit_board

  • id — integer — Primary key — NOT NULL
  • study_id — integer — Foreign key → study.id — NOT NULL
  • writer_id — integer — Foreign key → user.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • title — character — NOT NULL
  • content — character — NOT NULL

study_recruit_board_img

  • id — integer — Primary key — NOT NULL
  • study_recruit_board_id — integer — Foreign key → study_recruit_board.id — NOT NULL
  • imgUrl — character — NOT NULL
  • imgKey — character — NOT NULL

study_to_user

  • id — integer — Primary key — NOT NULL
  • user_id (id2) — integer — Foreign key → user.id — NOT NULL
  • study_id — integer — Foreign key → study.id — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • is_accept — integer — NOT NULL

user

  • id — integer — Primary key — NOT NULL
  • login_type — integer — NOT NULL
  • user_id — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

user_image

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user_profile.user_id — NOT NULL
  • img_url — character — NOT NULL
  • img_key — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

user_profile

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • nickname — character — NOT NULL
  • phone — character — NOT NULL
  • email — character — NOT NULL
  • bio — character — NOT NULL
  • name — character — NOT NULL

user_scheldule

  • id — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user_profile.user_id — NOT NULL
  • schedule — character — NOT NULL