Petmily_erd_public
Petmilly erd 입니다.
테이블 (17)
account
- id — bigint — 기본 키 — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(50) — NOT NULL
- is_ad_permission — tinyint(1) — NOT NULL — 0, 1
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- withdrew_at — datetime
- role — varchar(10)
- phone — varchar(13)
background
- id — bigint — 기본 키 — NOT NULL
- name — varchar(255) — NOT NULL
breed
- id — bigint — 기본 키 — NOT NULL
- species_id — bigint — 외래 키 → species.id — NOT NULL
- name — varchar(255) — NOT NULL
- default_image_url — varchar(255) — NOT NULL
diary
- id — bigint — 기본 키 — NOT NULL
- account_id — bigint — 외래 키 → account.id — NOT NULL
- profile_id — bigint — 외래 키 → profile.id — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_dt — datetime
diary_comment
- id — bigint — 기본 키 — NOT NULL
- diary_id — bigint — 외래 키 → diary.id — NOT NULL
- profile_id — bigint — 외래 키 → profile.id — NOT NULL
- content — text — NOT NULL
- created_dt — datetime — NOT NULL
- updated_dt — datetime — NOT NULL
- deleted_dt — datetime
diary_like
- id — bigint — 기본 키 — NOT NULL
- diary_id — bigint — 외래 키 → diary.id — NOT NULL
- profile_id — bigint — 외래 키 → profile.id — NOT NULL
- created_at — datetime
diary_media
- id — bigint — 기본 키 — NOT NULL
- diary_id — bigint — 외래 키 → diary.id — NOT NULL
- url — text — NOT NULL
- media_order — int — NOT NULL
- updated_at — datetime — NOT NULL
- type — varchar(100)
- created_at — datetime — NOT NULL
diary_reply
- id — bigint — 기본 키 — NOT NULL
- diary_comment_id — bigint — 외래 키 → diary_comment.id — NOT NULL
- profile_id — bigint — 외래 키 → profile.id — NOT NULL
- content — text — NOT NULL
- created_dt — datetime — NOT NULL
- updated_dt — datetime — NOT NULL
- deleted_dt — datetime
pet
- id — bigint — 기본 키 — NOT NULL
- account_id — bigint — 외래 키 → account.id — NOT NULL
- breed_id — bigint — 외래 키 → breed.id — NOT NULL
- pet_image_id — bigint — 외래 키 → pet_image.id — NOT NULL
- name — varchar(255) — NOT NULL
- birthday — date — NOT NULL
- gender — tinyint — NOT NULL
- background_id — bigint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- weight — double
pet_image
- id — bigint — 기본 키 — NOT NULL
- species_id — bigint — 외래 키 → species.id — NOT NULL
- url — varchar(100) — NOT NULL
pet_to_do_relationship
- id — bigint — 기본 키 — NOT NULL
- pet_id — bigint — 외래 키 → pet.id
- to_do_id — bigint — 외래 키 → to_do.id
profile
- id — bigint — 기본 키 — NOT NULL
- account_id — bigint — 외래 키 → account.id — NOT NULL
- name — varchar(50) — NOT NULL
- image_url — text
- push_token — varchar(255)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
push
- id — bigint — 기본 키 — NOT NULL
- profile_id — bigint — 외래 키 → profile.id — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- Field — datetime — NOT NULL
species
- id — bigint — 기본 키 — NOT NULL
- name — varchar(100) — NOT NULL
- basic_pet_image_id — bigint — 외래 키 → pet_image.id — NOT NULL
to_do
- id — bigint — 기본 키 — NOT NULL
- create_profile_id — bigint — 외래 키 → profile.id
- date — date — NOT NULL
- time — datetime
- is_all_day — tinyint(1) — NOT NULL
- content — varchar(255)
- tag — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- color — varchar(20) — NOT NULL
- is_using_alarm — tinyint(1) — NOT NULL
- unit — varchar(10) — null, time, day, week
- interval_num — bigint
- week_days — int — NOT NULL
- account_id — bigint — 외래 키 → account.id — NOT NULL
to_do_instance
- id — bigint — 기본 키 — NOT NULL
- to_do_id — bigint — 외래 키 → to_do.id — NOT NULL
- time — time — NOT NULL
- complete_profile_id — bigint — 외래 키 → profile.id
- complete_time — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- date — date — NOT NULL
to_do_week_day
- id — bigint — 기본 키 — NOT NULL
- to_do_id — bigint — 외래 키 → to_do.id — NOT NULL
- week_day — varchar(10) — NOT NULL