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