어린이zip

테이블 (14)

article (게시글)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key2) — NOT NULL — 외래 키 → user.id — NOT NULL
  • board_id (Key3) — NOT NULL — 외래 키 → board.id — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • created_at (Field3) — NOT NULL
  • updated_at (Field4) — NOT NULL
  • hit (Field5) — NOT NULL

board (게시판)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key2) — NOT NULL — 외래 키 → user.id — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NOT NULL

borough (Untitled2)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • name (Field) — NOT NULL
  • city_id (Key2) — NOT NULL — 외래 키 → city.id — NOT NULL

city (Untitled)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • name (Field) — NOT NULL

comment_article (게시글댓글)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • article_id (Key2) — NOT NULL — 외래 키 → article.id — NOT NULL
  • user_id (Key4) — NOT NULL — 외래 키 → user.id — NOT NULL
  • content (Field) — NOTNULL
  • created_at (Field2) — NOT NULL
  • updated_at (Field3) — NOT NULL

favorite (즐겨찾기)

  • id (Key3) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key) — NOT NULL — 외래 키 → user.id — NOT NULL
  • board_id (Key2) — NOT NULL — 외래 키 → board.id — NOT NULL
  • created_at (Field) — NOT NULL

kindergarten (어린이집)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • latitude (VARCHAR(20)) — NOT NULL
  • longitude (Field2) — NOT NULL
  • organization_name (Field3) — NOT NULL
  • director_name (Field4) — NOT NULL
  • establishment_type (Field5) — NOT NULL
  • created_date (Field6) — NOT NULL
  • agency (Field7) — NOT NULL
  • tel (Field8) — NOT NULL
  • homepage (Field9) — NOT NULL
  • start_time (Field10) — NOT NULL
  • finish_time (Field28) — NOT NULL
  • address (Field) — NOT NULL
  • general (Field14) — NOT NULL
  • infants (Field15) — NOT NULL
  • disabled (Field11) — NOT NULL
  • disabled_integration (Field16) — NOT NULL
  • after_school (Field17) — NOT NULL
  • after_school_inclusion (Field18) — NOT NULL
  • extension (Field19) — NOT NULL
  • holiday (Field20) — NOT NULL
  • all_day (Field21) — NOT NULL
  • part_time (Field22) — NOT NULL
  • school_bus (Field12) — NOT NULL
  • grade (Field13) — NOT NULL
  • score (Field27) — NOT NULL
  • area_columns (Field23) — NOT NULL
  • area_info (Field24) — NOT NULL
  • cctv_per_area (Field25) — NOT NULL
  • building_columns (Field26) — NOT NULL
  • building_info (Field29) — NOT NULL
  • cctv_columns (Field30) — NOT NULL
  • cctv_info (Field31) — NOT NULL
  • age_by_class_columns (Field32) — NOT NULL
  • age_by_class_info (Field33) — NOT NULL
  • staff_columns (Field34) — NOT NULL
  • staff_info (Field35) — NOT NULL
  • child_per_staff (Field36) — NOT NULL
  • continuous_columns (Field37) — NOT NULL
  • continuous_info (Field38) — NOT NULL
  • fee_columns (Field39) — NOT NULL
  • fee_info (Field40) — NOT NULL
  • other_fee_columns (Field41) — NOT NULL
  • other_fee_info (Field42) — NOT NULL
  • monthly_fee (Field43) — NOT NULL
  • special_activity_columns (Field44) — NOT NULL
  • special_activity_info (Field45) — NOT NULL
  • poisoning_columns (Field46) — NOT NULL
  • poisoning_info (Field47) — NOT NULL
  • air_quality_columns (Field48) — NOT NULL
  • air_quality_info (Field49) — NOT NULL
  • disinfection_columns (Field50) — NOT NULL
  • disinfection_info (Field51) — NOT NULL
  • water_quality_columns (Field52) — NOT NULL
  • water_quality_info (Field53) — NOT NULL
  • rating_certificate_columns (Field54) — NOT NULL
  • rating_certificate_info (Field55) — NOT NULL
  • rating_history_columns (Field56) — NOT NULL
  • rating_history_info (Field57) — NOT NULL
  • extension_class_status_columns (Field58) — NOT NULL
  • … +15

like_article (게시글좋아요)

  • id (Key3) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key) — NOT NULL — 외래 키 → user.id — NOT NULL
  • article_id (Key2) — NOT NULL — 외래 키 → article.id — NOT NULL

like_review (리뷰좋아요)

  • id (Key3) — NOT NULL — 기본 키 — NOT NULL
  • user_id (Key) — NOT NULL — 외래 키 → user.id — NOT NULL
  • review_id (Key2) — NOT NULL — 외래 키 → review.id — NOT NULL

review (리뷰)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • kindergarten_id (Key2) — NOT NULL — 외래 키 → kindergarten.id — NOT NULL
  • user_id (Key3) — NOT NULL — 외래 키 → user.id — NOT NULL
  • title (Field) — NOT NULL
  • created_at (Field2) — NOT NULL
  • updated_at (Field3) — NOT NULL
  • pros (Field5) — NOT NULL
  • cons (Field6) — NOT NULL
  • score_teacher (Field8) — NOT NULL
  • score_director (Field9) — NOT NULL
  • score_environment (Field10) — NOT NULL

user (사용자)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • password (Field10) — NOT NULL
  • email (Field9) — NOT NULL
  • username (Field8) — NOT NULL
  • nickname (Field4) — NOT NULL
  • address (Field3) — NULL
  • profile_image (Field7) — NULL
  • latitude (Field) — NULL — NOT NULL
  • longitude (Field2) — NULL
  • is_director (Field5) — NOT NULL
  • kindergarten_id (Field6) — NULL
  • is_superuser (Field11) — NOT NULL
  • is_staff (Field12) — NOT NULL

village (Untitled3)

  • id (Key) — NOT NULL — 기본 키 — NOT NULL
  • name (Field) — NOT NULL
  • borough_id (Key2) — NOT NULL — 외래 키 → borough.id — NOT NULL

weight (가중치)

  • user_id (Key) — NOT NULL — 외래 키 → user.id — NOT NULL
  • kindergarten_id (Key2) — NOT NULL — 외래 키 → kindergarten.id — NOT NULL
  • weight (Field) — NOT NULL

wishlist (찜)

  • id (Key4) — NOT NULL — 기본 키 — NOT NULL
  • kindergarten_id (Key) — NOT NULL — 외래 키 → kindergarten.id — NOT NULL
  • user_id (Key2) — NOT NULL — 외래 키 → user.id — NOT NULL