ERD

Tables (14)

ANSWER_IMAGE

  • id — BIGINT — Primary key — NOT NULL
  • quest_answer_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • is_reply — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

ANSWER_VIDEO

  • id — BIGINT — Primary key — NOT NULL
  • quest_answer_id — BIGINT — NOT NULL
  • video_url — VARCHAR(255) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

DIARY

  • id — BIGINT — Primary key — NOT NULL
  • memorial_book_id — BIGINT — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(255)
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

LAST_ACCESS_DATE

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • last_access_date — TIMESTAMP — NOT NULL

MEMORIAL_BOOK

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • is_open — TINYINT(1) — NOT NULL
  • is_activate — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

NOTIFICATION

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • device_token — VARCHAR(255) — NOT NULL

PET

  • id — BIGINT — Primary key — NOT NULL
  • guardian_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • age — TINYINT — NOT NULL
  • memorial_date — DATE — NOT NULL
  • species — VARCHAR(255) — NOT NULL
  • gender — CHAR(3) — NOT NULL
  • relationship — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • introduction — TEXT — NOT NULL
  • quest_index — TINYINT — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

PET_PERSONALITY

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • text — VARCHAR(255) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

QUEST

  • id — TINYINT — Primary key — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL

QUEST_ANSWER

  • id — BIGINT — Primary key — NOT NULL
  • quest_id — TINYINT — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • content — VARCHAR(255)
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

USER

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — CHAR(3) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • quest_reception_time — TIMESTAMP — NOT NULL
  • role — char(3) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

Untitled

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL

cheering_message

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • cheering — VARCHAR(255) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL

letter

  • id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — NOT NULL
  • parent_letter_id — BIGINT
  • content — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255)
  • is_user_send — TINYINT(1) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • status — TINYINT(1) — NOT NULL
  • is_memorial_book_added — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL