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