AQ_branch

Tables (12)

Child

  • id — BIGINT(32) — Primary key — NOT NULL — Child table id
  • name — VARCHAR(20) — NOT NULL — 자녀 이름
  • age — VARCHAR(2) — NOT NULL — 자녀 나이
  • gender — CHAR(1) — NOT NULL — 자녀 성별(M, W)
  • resident_registration_number — VARCHAR(13) — NOT NULL — 자녀 주민등록번호 123456-1234567
  • profile_image_url — TEXT — 프로필 이미지 url
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

ClinicHour

  • id — BIGINT(32) — Primary key — NOT NULL — ClinicHour table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • day_of_week — VARCHAR(3) — NOT NULL — 요일(Mon, Tue, Wen, Thu, Fri, Sat, Sun) + 공휴일(Holi)
  • opening_time — TIME — NOT NULL — 병원 오픈시간 HH:MM
  • closing_time — TIME — NOT NULL — 병원 마감시간 HH:MM
  • lunch_start_time — TIME — 점심(휴식)시간 시작 HH:MM
  • lunch_end_time — TIME — 점심(휴식)시간 종료 HH:MM
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Doctor

  • id — BIGINT(32) — Primary key — NOT NULL — Doctor table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • name — VARCHAR(5) — NOT NULL — 의사 이름
  • profile_image_url — VARCHAR(255) — 의사 프로필
  • description — VARCHAR(255) — 의사 소개
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Favor

  • id — BIGINT(32) — Primary key — NOT NULL — Favor table id
  • parent_id — BIGINT(32) — Foreign key → Parent.id — NOT NULL — Parent table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Hospital

  • id — BIGINT(32) — Primary key — NOT NULL — hospital table id
  • name — VARCHAR(32) — NOT NULL — 병원 이름
  • address — VARCHAR(255) — NOT NULL — 병원 주소
  • description — VARCHAR(255) — NOT NULL — 병원 소개
  • phone_number — VARCHAR(13) — NOT NULL — 병원 전화번호
  • status — VARCHAR(45) — NOT NULL — 진료중 OPEN. 진료마감 CLOSED
  • max_num_of_people — TINYINT — NOT NULL — 30분당 병원 예약 인원
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

HospitalImage

  • id — BIGINT(32) — Primary key — NOT NULL — HospitalImage table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • image_url — VARCHAR(255) — NOT NULL — 병원이미지 url (s3에 저장된 링크)
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Parent

  • id — BIGINT(32) — Primary key — NOT NULL — Parent table id
  • login_id — VARCHAR(32) — NOT NULL — 로그인 아이디
  • password — TEXT — NOT NULL — 로그인 비밀번호
  • nickname — VARCHAR(16) — NOT NULL — 회원 닉네임(리뷰용)
  • name — VARCHAR(5) — NOT NULL — 부모 이름(접수 시 사용)
  • age — VARCHAR(3) — NOT NULL — 부모 나이
  • gender — CHAR(1) — NOT NULL — 부모 성별(M, W)
  • phone_number — VARCHAR(13) — NOT NULL — 휴대폰번호 010-1234-5678
  • resident_registration_number — VARCHAR(13) — NOT NULL — 주민등록번호 123456-1234567
  • profile_image_url — TEXT — 부모 프로필 이미지 url
  • expired_date — TIMESTAMP — NOT NULL — 만료 날짜(토큰용) +30일 //다시 로그인
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

ParentChildLink

  • id — BIGINT(32) — Primary key — NOT NULL — parentChildLink table id
  • parent_id — BIGINT(32) — Foreign key → Parent.id — NOT NULL — Parent table id
  • child_id — BIGINT(32) — Foreign key → Child.id — NOT NULL — Child table id
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Reservation

  • id — BIGINT(32) — Primary key — NOT NULL — Reservation table id
  • parent_id — BIGINT(32) — Foreign key → Parent.id — NOT NULL — Parent table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • child_id — BIGINT(32) — NOT NULL — Child table id
  • time — DATETIME — NOT NULL — 환자가 선택한 병원 예약 시간 (30분단위아직 미정)
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Review

  • id — BIGINT(32) — Primary key — NOT NULL — Review table id
  • parent_id — BIGINT(32) — Foreign key → Parent.id — NOT NULL — Parent table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • title — VARCHAR(50) — NOT NULL — 리뷰 제목
  • score — TINYINT — NOT NULL — 리뷰 점수
  • description — VARCHAR(255) — NOT NULL — 리뷰 내용
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

ReviewImage

  • id — BIGINT(32) — Primary key — NOT NULL — ReviewImage table id
  • review_id — BIGINT(32) — Foreign key → Review.id — NOT NULL — Review table id
  • image_url — VARCHAR(255) — NOT NULL — 리뷰 이미지
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)

Visiting

  • id — BIGINT(32) — Primary key — NOT NULL — Visiting table id
  • hospital_id — BIGINT(32) — Foreign key → Hospital.id — NOT NULL — hospital table id
  • name — VARCHAR(20) — NOT NULL — 이름
  • resident_registration_number — VARCHAR(13) — NOT NULL — 주민(=외국인)등록 번호
  • created_by — TIMESTAMP — NOT NULL — 생성날짜
  • updated_by — TIMESTAMP — NOT NULL — 수정날짜
  • is_active — TINYINT — NOT NULL — 1(true활성화), 0(false비활성화)