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비활성화)