Jaram
Tables (16)
board
- id — int(11) — Primary key — NOT NULL
- type — varchar(20) — NOT NULL — 게시판의 종류: 육아 정보, 연령별 발달 특징
- user_id — int(11) — Foreign key → user.id — NOT NULL — 작성자
- file_cont_id — int(11) — Foreign key → file_container.id — 파일 컨테이너
- title — varchar(500) — NOT NULL
- body — mediumtext — NOT NULL
- read_cnt — int(11) — NOT NULL — 조회수
- category — varchar(20)
- age — int(11)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
excel_file
- id — int(11) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- file_id — int(12) — Foreign key → file.id
- created_at — datetime — NOT NULL
file
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.id
- title — varchar(400)
- type — varchar(100)
- path — varchar(150)
- width — int(11) — NOT NULL
- height — int(11) — NOT NULL
- file_size — int(11) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
file_cont_item
- file_id — int(11) — Foreign key → file.id — NOT NULL
- cont_id — int(11) — Foreign key → file_container.id — NOT NULL
- order — int(11) — NOT NULL
file_container
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.id — NOT NULL
- created_at — datetime — NOT NULL
klass
- id — int(11) — Primary key — NOT NULL
- organ_id — int(11) — Foreign key → organ.id — NOT NULL
- age — int(11)
- title — varchar(100)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
organ
- id — int(11) — Primary key — NOT NULL
- kind — varchar(50) — baby: 어린이집, child: 유치원
- title — varchar(100)
- phone — varchar(20)
- address — varchar(1000)
- code — varchar(200) — 어린이집을 분류하는 외부 유니크 키
- area1 — varchar(50)
- area2 — varchar(50)
- area3 — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
phone_auth
- id — int(11) — Primary key — NOT NULL
- phone — varchar(31) — NOT NULL
- auth — varchar(10) — NOT NULL
- expired_at — datetime — NOT NULL
- created_at — datetime — NOT NULL
popup
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.id
- file_cont_id — int(11) — Foreign key → file_container.id
- new_window — tinyint(1) — NOT NULL
- title — varchar(500) — NOT NULL
- url — varchar(1024)
- start — datetime
- end — datetime
- top — int(11)
- left — int(11)
- width — int(11)
- height — int(11)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
result
- id — int(12) — Primary key — NOT NULL
- yyyy — varchar(4) — NOT NULL
- tester_permission — int(11)
- user_id — int(12) — Foreign key → user.id
- name — varchar(100)
- gender — int(11)
- birth — varchar(8)
- age — varchar(30)
- url — text
- social_score — int(11)
- social_age — varchar(30)
- social_status — int(11)
- self_score — int(11)
- self_age — varchar(30)
- self_status — int(11)
- large_score — int(11)
- large_age — varchar(30)
- large_status — int(11)
- small_score — int(11)
- small_age — varchar(30)
- small_status — int(11)
- express_score — int(11)
- express_age — varchar(30)
- express_status — int(11)
- understand_score — int(11)
- understand_age — varchar(30)
- understand_status — int(11)
- word_score — int(11)
- word_age — varchar(30)
- word_status — int(11)
- number_score — int(11)
- number_age — varchar(30)
- number_status — int(11)
- total_score — int(11)
- total_age — varchar(30)
- total_status — int(11)
- check_count — int(11)
- review — mediumtext
- comment — mediumtext
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
result_play
- id — int(11) — Primary key — NOT NULL
- result_id — int(11) — Foreign key → result.id
- category — varchar(20) — NOT NULL
- age — int(11) — NOT NULL
- board_id — int(11) — Foreign key → board.id
- created_at — datetime — NOT NULL
sms_log
- id — int(11) — Primary key — NOT NULL
- sender — varchar(20) — NOT NULL
- receiver — varchar(20) — NOT NULL
- text — varchar(300) — NOT NULL
- result — tinyint(1) — NOT NULL — 0: nothing, 1: 실패, 2: 성공
- created_at — datetime — NOT NULL
teacher_answer
- id — int(11) — Primary key — NOT NULL
- teacher_id — int(11) — Foreign key → user.id — NOT NULL
- user_id — int(11) — Foreign key → user.id — NOT NULL
- issued_date — varchar(20) — NOT NULL
- data — mediumtext
- created_at — datetime — NOT NULL
token
- token — varchar(120) — Primary key — NOT NULL
- atoken — varchar(120) — NOT NULL
- user_id — int(11) — Foreign key → user.id — NOT NULL
- permissions — text
- session — mediumtext — NOT NULL
- expired_at — datetime — NOT NULL
- created_at — datetime — NOT NULL
- deleted_at — datetime
user
- id — int(11) — Primary key — NOT NULL
- yyyy — varchar(4) — NOT NULL
- permission — int(11) — NOT NULL — 1: 원아, 2: 선생님, 3: 기관, 4: ADMIN Page 사용자, 5: Admin Page 내 ID관리자
- account — varchar(150) — NOT NULL — 관리자는 직접 입력하거나 설정하여 사용하고,\n선생님과 학부모의 경우 phone과 동일한 값을 갖는다. 다만 전화번호를 가질 때는 숫자만 갖는다.
- password — varchar(200)
- phone — varchar(50)
- email — varchar(500)
- name — varchar(100)
- gender — int(11) — NOT NULL — 0: 알수 없음, 1: 남성, 2: 여성
- birth — varchar(8)
- last_login_at — datetime
- organ_name — varchar(100) — 원아, 선생님의 경우에만 새팅된다. 그 외는 무시된다.
- class_name — varchar(100)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
user_survey
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.id — NOT NULL
- key — varchar(30)
- value — text
- created_at — datetime — NOT NULL