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