test
Tables (23)
academy
- idx — unsigned — NOT NULL
- name — varchar(255)
- business_number — char(10)
- business_registration_file_path — text
- logo_img_path — text
- logo_img_thumbnail_path — text
academy_program
- idx — unsigned — NOT NULL
- academy_idx — unsigned — NOT NULL
- program_idx — unsigned — NOT NULL
attendance
- idx — unsigned — NOT NULL
- student_idx — unsigned — NOT NULL
- schedule_idx — unsigned — NOT NULL
- attendance — VARCHAR(255)
- attendance_count — int
- memo — text
class
- idx — unsigned — NOT NULL
- academy_idx — unsigned — NOT NULL
- idx2 — unsigned — NOT NULL
- name — varchar(100)
- type — varchar(50)
- payment_number — int
- price — int
- start_date (Field4) — date
- end_date — date
class_day
- idx — unsigned — NOT NULL
- class_idx — unsigned — NOT NULL
- day — varchar(3)
- start_time — time
- end_time — time
class_student
- idx — unsigned — NOT NULL
- class_idx — unsigned — NOT NULL
- student_idx — unsigned — NOT NULL
- start_date — date
- end_date — date
- recent_payment_date — date
- next_payment_date — date
- billing_payment_date — date
- due_date — int
- billing_price — int
- Field — VARCHAR(255)
keyword
- idx — unsigned — NOT NULL
- program_idx — unsigned — NOT NULL
material
- idx — unsigned — NOT NULL
- program_idx — unsigned — NOT NULL
parents
- idx — unsigned — NOT NULL
- name — varchar(50)
- phone — varchar(13)
payment_history
- Key — VARCHAR(255) — NOT NULL
- Key2 — VARCHAR(255) — NOT NULL
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
portfolio
- idx — unsigned — NOT NULL
- class_student_idx — unsigned — NOT NULL
- artwork_img_path — text
- title — varchar(50)
- round — int
- group_feedback — text
- personal_feedback — text
- sequence — int
portfolio_tag
- idx — unsigned — NOT NULL
- portfolio_idx — unsigned — NOT NULL
- tag_idx — unsigned — NOT NULL
portfolio_tool
- idx — unsigned — NOT NULL
- portfolio_idx — unsigned — NOT NULL
- tool_idx — unsigned — NOT NULL
program
- idx — unsigned — NOT NULL
- name — varchar(255)
- target_age — varchar(50)
- program_type — varchar(50)
- Field — varchar(10)
- desc — text
round_detail_desc
- idx — unsigned — NOT NULL
- program_idx — unsigned — NOT NULL
- round — int
- desc — text
schedule
- idx — unsigned — NOT NULL
- class_idx — unsigned — NOT NULL
- round — int
- date — date
- type — VARCHAR(255)
student
- idx — unsigned — NOT NULL
- academy_idx — unsigned — NOT NULL
- parent_idx — unsigned — NOT NULL
- name — varchar(50)
- gender — char(1)
- birth_date — date
- relation — varchar(50)
tag
- idx — unsigned — NOT NULL
- Field — VARCHAR(255)
tool
- idx — unsigned — NOT NULL
- Field — VARCHAR(255)
user
- idx — unsigned — NOT NULL
- email — varchar(50)
- password — varchar(20)
- Field — varchar(50)
- phone — varchar(13)
- notification — boolean
- role (역할) — char(1)
user_academy
- idx — unsigned — NOT NULL
- user_idx — unsigned — NOT NULL
- academy_idx — unsigned — NOT NULL
- is_approve — boolean
- nickname — varchar(50)
- 입사일 (Field) — date
- 퇴사일 (Field2) — date
user_class
- idx — unsigned — NOT NULL
- user_idx — unsigned — NOT NULL
- class_idx — unsigned — NOT NULL
user_schedule
- idx — unsigned — NOT NULL
- user_idx — unsigned — NOT NULL
- schedule_idx — unsigned — NOT NULL