주토피아 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