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