[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