Academy

Tables (19)

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

Copy Of FacilityReview (CopyOf시설 리뷰)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • EventDetail (행사내용) — text
  • EventName (행사명) — text
  • EventImage (사진) — image
  • Field (시설명) — text
  • created_at (생성일자) — DateTime
  • facility (시설) — Facility — Foreign key → Facility.unique_id — NOT NULL

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