onkids

Tables (12)

answer (Untitled9)

  • id — 고유식별자 — Primary key — NOT NULL
  • content (내용) — text
  • createdAt (생성일) — Date
  • author (답변작성자) — user

first_report_intelligence (Untitled8)

  • id — Primary key — NOT NULL
  • report_mediaId (미디어고유아이디) — Foreign key → report_media.id — NOT NULL
  • intelligence (지능명)
  • createdAt (생성일)

first_report_intelligence_result (CopyOfUntitled8)

  • id — Primary key — NOT NULL
  • first_report_intelligenceId (1차지능 ID) — Foreign key → first_report_intelligence.id — NOT NULL
  • observed_start (관찰시작시간) — Date
  • observed_end (관찰종료시간) — Date
  • criteria (분석기준)
  • observation_basis (관찰 근거)
  • evaluation (평가점수)

intelligence_thumbnail (CopyOfCopyOfUntitled7)

  • id — Primary key — NOT NULL
  • first_report_intelligenceId (1차지능 ID) — Foreign key → first_report_intelligence.id — NOT NULL
  • url (파일 저장 경로)
  • size (파일크기)
  • type (파일타입)
  • createdAt (생성일)
  • name (Field)
  • indv_thumb_score (점수)

kids (Untitled2)

  • id — 고유식별자 — Primary key — NOT NULL
  • userId (유저id) — 고유식별자 — Foreign key → user.id — NOT NULL
  • kidName (아이이름) — varchar
  • kidBirth (아이생년월일) — Date
  • gender (성별) — varchar
  • Field2

media_thumbnail (CopyOfUntitled7)

  • id — Primary key — NOT NULL
  • report_mediaId (미디어고유아이디) — Foreign key → report_media.id — NOT NULL
  • url (파일 저장 경로)
  • size (파일크기)
  • type (파일타입)
  • createdAt (생성일)
  • name (Field)

question (Untitled4)

  • id — 고유식별자 — Primary key — NOT NULL
  • content (내용) — text
  • questionType (타입) — enum(growth, report)
  • userType (답변유저 타입) — enum(expert, user)
  • isPrivate (비공개여부) — boolean
  • author (작성자) — user
  • isReserve (예약여부) — boolean
  • isExpertAnswer (전문가 답변 여부) — boolean
  • answer (답변 리스트) — answer list

report (Untitled3)

  • id — 고유식별자 — Primary key — NOT NULL
  • kidsId (아이id) — 고유식별자 — Foreign key → kids.id — NOT NULL
  • createdAt (생성일) — date
  • updatedAt (수정일) — date

report_media (Untitled7)

  • id — Primary key — NOT NULL
  • id (id2) — 고유식별자 — Foreign key → report.id — NOT NULL
  • url (파일 저장 경로)
  • size (파일크기)
  • type (파일타입)
  • createdAt (생성일)
  • name (Field)

second_report_intelligence (Untitled5)

  • id — 고유식별자 — Primary key — NOT NULL
  • reportId (리포트id) — 고유식별자 — Foreign key → report.id — NOT NULL
  • intelligence (지능명) — varchar
  • final_summary (지능 총평) — text
  • score (점수) — int
  • percentile (백분위) — int

second_report_intelligence_category (Untitled6)

  • id — 고유식별자 — Primary key — NOT NULL
  • intelligenceId (지능아이디) — 고유식별자 — Foreign key → second_report_intelligence.id — NOT NULL
  • category (카테고리 번호) — int
  • observation (관찰여부) — true
  • summary (관찰요약) — summary

user (Untitled)

  • id — 고유 식별자 — Primary key — NOT NULL
  • nickName (닉네임) — varchar
  • name (이름) — varchar
  • birth (생년월일) — Date
  • phoneNumber (전화번호) — varchar