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