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