yureka
Tables (4)
INTERESTS (Untitled4)
- Id (PK) — NOTNULL — Primary key — NOT NULL
- user_id (PK2) — NOTNULL — Foreign key → STUDENT_PROFILES.user_id — NOT NULL
- interest_category (enum) — NOTNULL
MENTOR_PROFILES (Untitled2)
- user_id (PK) — NOTNULL — Foreign key → Users.id — NOT NULL
- phone_number (전화번호) — NOTNULL
- affiliation_type (소속타입) — NULL
- affiliation_name (소속명) — NULL
- major (전공) — NOTNULL
- introduction (한줄 소개) — NULL
STUDENT_PROFILES (Untitled3)
- user_id (PK) — NOTNULL — Foreign key → Users.id — NOT NULL
- gender (성별) — NOTNULL
- phone_number (전화번호) — NOTNULL
- school_name (학교명) — NULL
- school_type (학교유형) — NULL
- track (계열) — NULL
- grade (학년) — NULL
- address (주소) — NOTNULL
- detail_address (상세주소) — NOTNULL
- admission_type (입시전형) — NULL
- target_university (목표대학) — NULL
- preferred_role (선호하는역할) — NULL
Users (Untitled)
- id (PK) — NOTNULL — Primary key — NOT NULL
- name (이름) — NOTNULL
- password (비밀번호) — NULL
- auth_provider (회원가입 방식) — NOTNULL
- user_type (유저타입) — NOTNULL
- status (계정상태) — NOTNULL
- created_at (생성시간) — NOTNULL
- modified_at (수정시간) — NOTNULL