[PM] New ERD for PlayingMore

Tables (7)

Device

  • device_id — varchar(255) — Primary key — NOT NULL
  • member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
  • device_type — varchar(20)
  • ssid — varchar(255) — NOT NULL
  • is_connection — boolean — NOT NULL
  • color — varchar(255)
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp

block_data

  • block_data_id — varchar(255) — Primary key — NOT NULL
  • member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
  • s1 — int — NOT NULL
  • s2 — int — NOT NULL
  • s3 — int — NOT NULL
  • s4 — int — NOT NULL
  • s5 — int — NOT NULL
  • s6 — int — NOT NULL
  • s7 — int — NOT NULL
  • s8 — int — NOT NULL
  • s9 — int — NOT NULL
  • s10 — int — NOT NULL
  • s11 — int — NOT NULL
  • s12 — int — NOT NULL
  • total_sum — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp

certification

  • certification_id — varchar(255) — Primary key — NOT NULL
  • phone_number — varcahr(50) — NOT NULL
  • carrier — varchar(10)
  • created_at — timestamp — NOT NULL
  • certification_number — varchar(6) — NOT NULL
  • is_checked — boolean — NOT NULL
  • modified_at — timestamp
  • createdAt — timestamp

member

  • member_id — varchar(255) — Primary key — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(50) — NOT NULL
  • carrier — varchar(10) — NOT NULL
  • social_type — varchar(5) — NOT NULL
  • social_key — varchar(255)
  • role — varchar(30) — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp
  • is_active — boolean — NOT NULL
  • deleted_at — timestamp

pet

  • pet_id — varchar(255) — Primary key — NOT NULL
  • member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
  • pet_name — varchar(255) — NOT NULL
  • birthday — timestamp — NOT NULL
  • gender — varchar(10) — NOT NULL
  • breed — varchar(255)
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp
  • is_active — boolean — NOT NULL
  • deleted_at — timestamp

refresh_token

  • refresh_token_id — varchar(255) — Primary key — NOT NULL
  • role — varchar(10) — NOT NULL
  • login_id — varchar(50) — NOT NULL
  • token — varchar(1000) — NOT NULL
  • is_active — boolean — NOT NULL
  • createdAt — timestamp — NOT NULL
  • expiredAt — timestamp — NOT NULL

terms

  • terms_id — varchar(255) — Primary key — NOT NULL
  • member_id — varchar(255) — Foreign key → member.member_id — NOT NULL
  • terms_name — varchar(255) — NOT NULL
  • terms_type — varchar(10) — NOT NULL
  • terms_version — varcahr(50) — NOT NULL
  • created_at — timestamp — NOT NULL
  • modified_at — timestamp
  • is_active — boolean — NOT NULL
  • deleted_at — timestamp