UserDomain
Tables (6)
DDay (pts_d_day)
- d_day_idx — Bigint — Primary key — NOT NULL
- date — Date
- name — VARCHAR
- user_idx — Bigint — Foreign key → User.user_idx — NOT NULL
Device (pts_user_device)
- device_idx — Bigint — Primary key — NOT NULL
- registered_at (created_at) — Timestamp
- deleted_at — Timestamp — NOT NULL
- fcm_token — VARCHAR
- mac_addr — VARCHAR — FCM token으로 대체 가능하다면 없어도 될 것 같음
- model_name — VARCHAR
- app_version — VARCHAR
- user_idx — Bigint — Foreign key → User.user_idx — NOT NULL
LoginMethod (pts_login_method)
- login_method_idx — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → User.user_idx — NOT NULL
- created_at — Timestamp
- deleted_at — Timestamp — NOT NULL
- login_type — CHAR
- login_id — VARCHAR
- login_pw — VARCHAR
User (pts_user)
- user_idx — Bigint — Primary key — NOT NULL
- registered_at (created_at) — Timestamp
- deleted_at — Timestamp — NOT NULL
- name — VARCHAR
- nickname — VARCHAR
- email — VARCHAR(128)
- phone — VARCHAR(20)
- birth — Timestamp
- gender — CHAR(1)
- study_goal — VARCHAR(128)
UserDeleted (pts_user_deleted)
- user_delete_idx (user_deleted_idx) — Bigint — Primary key — NOT NULL
- user_idx — Bigint — Foreign key → User.user_idx — NOT NULL
- deleted_at (created_at) — Timestamp
- blocked_until — Timestamp
- phone — VARCHAR
- email — VARCHAR
Wallet (pts_wallet)
- wallet_idx — Bigint — Primary key — NOT NULL
- created_at — Timestamp
- updated_at — Timestamp
- deleted_at — Timestamp
- reward_credit — int — 기존의 studyCredit
- user_idx — Bigint — Foreign key → User.user_idx — NOT NULL