어린이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