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)