Academy
Tables (18)
Address (주소)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- addr1 (시도) — text
- addr2 (시군구) — text
- addr3 (읍면동) — text
Certify (인증)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- certify_type (인증 유형) — CERTIFY_TYPE
- code (인증 코드) — text
- phone (휴대폰 번호) — text
- expired_at (만료 시간) — DateTime
Facility (시설)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- facility_type (시설 유형) — FACILITY_TYPE
- logo_image (로고 이미지) — image
- introduce_image_list (소개 이미지 리스트) — List<Image>
- name (시설명) — text
- address (시설 주소) — text
- address_detail (시설 상세주소) — text
- post_no (시설 우퍈번호) — text
- phone (전화번호) — text
- introduce (소개글) — text
- business_file (사업자 등록증 파일) — File
- teacher_list (선생님 리스트) — List<Teacher> — Foreign key → Teacher.unique_id — NOT NULL
- score (리뷰 점수) — number
FacilityReview (시설 리뷰)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- score (점수) — number
- contents (내용) — text
- created_at (생성일자) — DateTime
- facility (시설) — Facility — Foreign key → Facility.unique_id — NOT NULL
Faq (자주하는 질문)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- question (질문) — text
- contents (내용) — text
- sort_num (정렬 순서) — number
FoodDrink (식음료)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- name (이름) — text
- price (가격) — number
- Field
Inquiry (문의)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- inquiry_type (문의 유형) — INQUIRY_TYPE
- title (문의 제목) — text
- contents (문의 내용) — text
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
KidsNote (키즈노트)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- teacher_name (선생님 이름) — text
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- facility (시설) — Facility — Foreign key → Facility.unique_id — NOT NULL
- teacher (선생님) — Teacher — Foreign key → Teacher.unique_id — NOT NULL
- created_at (생성 일자) — DateTime
- contents_list (내용 리스트) — List<KidsNoteContents> — Foreign key → KidsNoteContents.unique_id — NOT NULL
KidsNoteContents (키즈노트 내용)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- contents_type (내용 유형) — CONTENTS_TYPE
- image (이미지) — Image
- text (텍스트) — text
- sort_num (정렬 순서) — number
Notice (공지사항)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- title (제목) — text
- contents (내용) — text
- created_at (생성일자) — DateTime
Parent (부모 정보)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- name (학부모 이름) — text
- parent_type (학부모 유형) — PARENT_TYPE
- child_birth_at (자녀 생년월일) — Date
- child_type (자녀 유형) — CHILD_TYPE
- note (특이사항) — text
Room (방)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- no (방 번호) — text
- Field
RoomResource (방 비치 식음료)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- room (방) — Room — Foreign key → Room.unique_id — NOT NULL
- food_drink (식음료) — FoodDrink — Foreign key → FoodDrink.unique_id — NOT NULL
- count (비치 수) — number
Teacher (선생님)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- name (이름) — text
- profile_image (프로필 이미지) — image
- age (나이) — number
- gender_type (성별 유형) — GENDER_TYPE
Term (약관)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- term_type (약관 유형) — TERM_TYPE
- contents (내용) — text
- last_update_at (마지막 업데이트 일시) — DateTime
User (유저)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- email (이메일) — text
- password (패스워드) — text
- init_password (초기 패스워드) — text
- control_password (조작 패스워드) — text
- login_type (로그인 유형) — LOGIN_TYPE
- user_type (유저 유형) — USER_TYPE
- user_state (유저 상태) — USER_STATE
- phone (휴대폰번호) — text
- parent (부모 정보) — Parent — Foreign key → Parent.unique_id — NOT NULL
- facility (시설 정보) — Facility — Foreign key → Facility.unique_id — NOT NULL
- address (주소) — Address — Foreign key → Address.unique_id — NOT NULL
- is_notification (알림 여부) — boolean
- user_facility_like (시설 좋아요 리스트) — List<Facility> — Foreign key → Facility.unique_id — NOT NULL
UserFacility (유저 가입 시설)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- user (유저) — User — Foreign key → User.unique_id — NOT NULL
- facility (시설) — Facility — Foreign key → Facility.unique_id — NOT NULL
- join_state (가입 상태) — JOIN_STATE
UserNotification (유저 알림)
- unique_id (고유 번호) — text — Primary key — NOT NULL
- notification_type (알림 유형) — NOTIFICATION_TYPE
- title (제목) — text
- created_at (생성 일자) — DateTime
- user (유저) — User — Foreign key → User.unique_id — NOT NULL