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