hellogsm

Tables (8)

access_token_blacklist

  • access_token — varchar(500) — NOT NULL
  • expired_date — timestamp

admin

  • admin_idx — int
  • id — varchar(50) — NOT NULL
  • password — varchar(50) — NOT NULL

application

  • application_idx — int
  • registration_number — smallint
  • is_final_submission — tinyint(1)
  • is_document_reception — tinyint(1)
  • first_result_screening — varchar(20)
  • final_result_screening — varchar(20)
  • guardian_cellphone_number — varchar(20) — NOT NULL
  • teacher_cellphone_number — varchar(20) — NOT NULL
  • school_name — varchar(50) — NOT NULL
  • screening — varchar(20) — NOT NULL
  • user_idx — bigint — NOT NULL

application_details

  • application_idx — int — NOT NULL
  • address — varchar(50) — NOT NULL
  • address_details — varchar(50) — NOT NULL
  • telephone_number — varchar(20) — NOT NULL
  • guardian_name — varchar(20) — NOT NULL
  • guardian_relation — varchar(20) — NOT NULL
  • teacher_name — varchar(20) — NOT NULL
  • school_location — varchar(50) — NOT NULL
  • education_status — varchar(20) — NOT NULL
  • graduation_year — varchar(20) — NOT NULL
  • graduation_month — varchar(20) — NOT NULL
  • first_wanted_major — varchar(20) — NOT NULL
  • second_wanted_major — varchar(20) — NOT NULL
  • third_wanted_major — varchar(20) — NOT NULL
  • major_result — varchar(20)

application_image

  • user_idx — bigint — NOT NULL
  • ID_photo_url — varchar(500) — NOT NULL

application_score

  • application_idx — int — NOT NULL
  • score_2_1 — decimal(6, 3) — NOT NULL
  • score_2_2 — decimal(6, 3) — NOT NULL
  • score_3_1 — decimal(6, 3) — NOT NULL
  • general_curriculum_score_subtotal — decimal(6, 3) — NOT NULL
  • art_sports_score — decimal(6, 3) — NOT NULL
  • curriculum_score_subtotal — decimal(6, 3) — NOT NULL
  • attendance_score — decimal(3) — NOT NULL
  • volunteer_score — decimal(3) — NOT NULL
  • non_curriculum_score_subtotal — decimal(3) — NOT NULL
  • score_total — decimal(6, 3) — NOT NULL
  • personality_evaluation_score — decimal(6, 3)

refresh_token

  • user_idx — bigint — NOT NULL
  • refresh_token — varchar(500) — NOT NULL

user

  • user_idx — bigint — NOT NULL
  • user_img — varchar(500)
  • name — varchar(20)
  • birth — date
  • gender — varchar(20)
  • cellphone_number — varchar(20)