MVPversion_01_2

테이블 (3)

학기의 과목 (academic_terms)

  • academic_term_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • academic_term_name (UQ(within user))

회원 (Users)

  • user_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • user_email (UQ(함수형)) — STR(320)
  • user_password_hash (Field) — STR(255)
  • user_status (Field2) — ENUM_user_status
  • user_created_at (Field3) — TS
  • user_last_login_at (Field4) — TS

회원 프로필 (User_profiles)

  • user_profile_name (Field) — STR(80)
  • user_profile_school (Field2) — STR(120)
  • user_profile_birthday (Field3) — STR(6)
  • user_profile_timezone (Field4) — STR(32)
  • user_profile_created_at (Field5) — TS