주토피아 ERD

테이블 (20)

hopital_animal

  • PK2 — int — NOT NULL
  • PK — int — NOT NULL

hospital_info

  • PK — int — NOT NULL
  • 병원이름 (name) — varchar(64)
  • 병원주소 (address) — varchar(100)
  • 홈페이지 (homepage) — varchar(64)
  • 전화번호 (phone) — varchar(64)
  • 이메일 (email) — varchar(64)
  • 생성일자 (created_at) — timestamp

hospital_specialty

  • PK — int — NOT NULL
  • specialty_id — int — NOT NULL

insurance_product

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • coverage_percent — INT — NOT NULL
  • monthly_fee_range — VARCHAR(50)
  • max_coverage — INT
  • species — ENUM('dog', 'cat', 'all')
  • join_condition — TEXT
  • coverage_items — TEXT
  • precautions — TEXT
  • description — TEXT
  • created_at — DATETIME

insurance_qna

  • qna_id — INT
  • product_id — INT
  • question — TEXT — NOT NULL
  • answer — TEXT
  • created_at — DATETIME

lost_animal_images

  • image_id — INT
  • image_url — VARCHAR(255) — NOT NULL
  • ordering — INT
  • post_id — INT

lost_animal_videos

  • video_id — INT
  • video_url — VARCHAR(255) — NOT NULL
  • post_id — INT

lost_animals

  • post_id — INT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • lost_location — VARCHAR(255)
  • lost_time — DATETIME
  • contact_phone — VARCHAR(30)
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • user_id — INT

parttime_job

  • job_id — INT
  • title — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100) — NOT NULL
  • pay — INT — NOT NULL
  • work_date — DATETIME — NOT NULL
  • owner_id — VARCHAR(50) — NOT NULL
  • pet_info — VARCHAR(100)
  • memo — TEXT
  • created_at — DATETIME

parttime_job_applicant

  • applicant_id — INT
  • job_id — INT — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • rating — FLOAT
  • review_count — INT
  • introduction — TEXT
  • created_at — DATETIME

parttime_job_comment

  • comment_id — INT
  • job_id — INT — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

possible_animal

  • PK — int — NOT NULL
  • 진료가능동물 (species) — ENUM('MAMMAL, BIRD, REPTILE, AMPHIBIAN, ARTHROPOD, FISH')

post_comments

  • comment_id — INT
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • user_id — INT
  • post_id — INT

post_images

  • image_id — INT
  • image_url — VARCHAR(255) — NOT NULL
  • ordering — INT
  • post_id — INT

post_likes

  • like_id — INT
  • created_at — DATETIME
  • UNIQUE(post_id, — user_id)
  • post_id — INT
  • user_id — INT

post_videos

  • video_id — INT
  • video_url — VARCHAR(255) — NOT NULL
  • post_id — INT

posts

  • post_id — INT
  • category — ENUM('자유글', '질문글', '자랑글')
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • like_count — INT
  • comment_count — INT
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — INT

specialty

  • specialty_id — int — NOT NULL
  • 진료과목 (category) — ENUM('INTERNAL', 'SURGICAL', 'DIAGNOSTIC', 'PREVENTIVE', 'SPECIALIZED') — NOT NULL

user_pets

  • pet_id — INT
  • name — VARCHAR(50) — NOT NULL
  • species — VARCHAR(100) — NOT NULL
  • breed — VARCHAR(100)
  • birth_date — DATE
  • created_at — DATETIME
  • user_id — INT

users

  • user_id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • intro — VARCHAR(255)
  • phone — VARCHAR(20)
  • profile_img — VARCHAR(255)
  • created_at — DATETIME