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