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