findora

Tables (16)

bookmark

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • post_id — bigint — Foreign key → posts.id — NOT NULL

categories

  • id — bigint — Primary key — NOT NULL
  • name — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • visibility — enum — NOT NULL

comment

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • parent_id — bigint — Foreign key → comment.id
  • post_id — bigint — Foreign key → posts.id — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

departments

  • id — bigint — Primary key — NOT NULL
  • university_id — bigint — Foreign key → universities.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL

email_verification

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • token — varchar(100) — NOT NULL
  • sent_at — timestamp — NOT NULL
  • verified_at — timestamp — NOT NULL
  • expires_at — timestamp — NOT NULL

graduate_schools

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255)
  • logo_url — VARCHAR(255) — NOT NULL
  • student_count — int
  • international_ratio — VARCHAR(255)
  • race_ethnicity — VARCHAR(255)
  • gender_ratio — VARCHAR(255)
  • acceptance_rate — VARCHAR(255)

laboratories

  • id — VARCHAR(255) — Primary key — NOT NULL
  • department_id — bigint — Foreign key → departments.id — NOT NULL
  • homepage — VARCHAR(255)
  • description — text

likes

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • post_id — bigint — Foreign key → posts.id
  • comment_id — bigint — Foreign key → comment.id
  • created_at — timestamp — NOT NULL

posts

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — Foreign key → categories.id — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

professors

  • id — bigint — Primary key — NOT NULL
  • id2 — bigint — Foreign key → departments.id — NOT NULL
  • lab_id — bigint — Foreign key → laboratories.id — NOT NULL
  • name — varchar(100) — NOT NULL
  • email — varchar(255)
  • homepage — varchar(255)
  • profile_url — varchar(255)
  • keywords — varchar(255)
  • Field — varchar(255)
  • articles_count — int

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • user_email — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • created_by_ip — VARCHAR(255)
  • revoked_by_ip — VARCHAR(255)
  • reason_revoked — VARCHAR(255)

reviews

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • lab_id — bigint — Foreign key → laboratories.id — NOT NULL
  • professor_id — bigint — Foreign key → professors.id — NOT NULL
  • teaching_score — int — NOT NULL
  • research_score — int — NOT NULL
  • availability_score — int — NOT NULL
  • facilities_score — int — NOT NULL
  • output_score — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • review — text

social_auth

  • id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(255) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • access_token — VARCHAR(255)
  • refresh_token — VARCHAR(255)
  • connected_at — VARCHAR(255) — NOT NULL

universities

  • id — bigint — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • logo_url — VARCHAR(255) — NOT NULL

user_agreement

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → users.id — NOT NULL
  • version — VARCHAR(20) — NOT NULL — 약관 버전 (예: v1.0, v1.1 등)
  • created_at — timestamp — NOT NULL — 레코드 생성 시각
  • type — ENUM('SERVICE', 'PRIVACY', 'MARKETING') — NOT NULL — SERVICE=서비스 약관, PRIVACY=개인정보 수집·이용 동의(필수), MARKETING=광고성 정보 수신 동의(선택)
  • agreed — boolean — NOT NULL

users

  • id — bigint — Primary key — NOT NULL
  • login_id — varchar(100) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • role — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • email_verified — boolean — NOT NULL