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