erd
테이블 (6)
긴급 돌봄 신청서 (urgent_form)
- num — bigint — 기본 키 — NOT NULL
- care_date — date — NOT NULL
- region — varchar(100) — NOT NULL
- category — varchar(15) — NOT NULL
- location — varchar(30) — NOT NULL
- care_time — varchar(20) — NOT NULL
- phone_number — varchar(20) — NOT NULL
- information — text — NOT NULL
- state — varchar(10) — NOT NULL
- mem_num — bigint — NOT NULL
긴급 돌봄 예약 (urgent_reservation)
- res_num — bigint — 기본 키 — NOT NULL
- care_date — date — NOT NULL
- category — varchar(15) — NOT NULL
- form_num — bigint — NOT NULL
- mem_num — bigint — NOT NULL
돌봄 신청서 (care_form)
- mem_num — bigint — 기본 키 — NOT NULL
- title — varchar(30) — NOT NULL
- care_type — varchar(15) — NOT NULL
- care_day — varchar(20) — NOT NULL
- care_start_time — time — NOT NULL
- care_end_time — time — NOT NULL
- region — varchar(100) — NOT NULL
- pay — int — NOT NULL
- request — text — NOT NULL
이력서 (resume)
- mem_num — bigint — 기본 키 — NOT NULL
- name — varchar(20) — NOT NULL
- age — int — NOT NULL
- phone_number — varchar(20) — NOT NULL
- region — varchar(40) — NOT NULL
- care_type — varchar(15) — NOT NULL
- career — varchar(30) — NOT NULL
- introduction — text — NOT NULL
- certificate — varchar(500)
- photo — varchar(500)
- care_day — varchar(20) — NOT NULL
- care_start_time — time — NOT NULL
- care_end_time — time — NOT NULL
- certificate_text — varchar(500)
평점 (review_average)
- mem_num — bigint — 기본 키 — NOT NULL
- average — float — NOT NULL
- total — float — NOT NULL
- count — int — NOT NULL
후기 (review)
- num — bigint — 기본 키 — NOT NULL
- star — int — NOT NULL
- comment — varchar(150) — NOT NULL
- detail — text
- res_num — bigint — NOT NULL
- writer — bigint — NOT NULL
- receiver — bigint — NOT NULL