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