test
Tables (20)
AI_HACKATHON_ADMIN_USER
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_company_id — VARCHAR(50) — Primary key — NOT NULL
- hct_admin_nickname — VARCHAR(50)
- hct_admin_password — VARCHAR(255)
- hct_admin_salt — VARCHAR(50)
- hct_admin_division — VARCHAR(50)
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_ATTEND_USER_LIST
- hct_attend_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_user_id — INT — Primary key — NOT NULL
- hct_attend_parent_id — INT
- hct_user_team_name — varchar(255)
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_COMPANY
- hct_company_id — INT — Primary key — NOT NULL
- hct_company_name — VARCHAR(50)
- hct_company_description — TEXT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_DATA
- hct_data_id — INT — Primary key — NOT NULL
- hct_sked_id — VARCHAR(50) — Primary key — NOT NULL
- hct_data_description — TEXT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_DISCUSSION
- hct_discu_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_user_id — INT — Primary key — NOT NULL
- hct_discu_title — VARCHAR(100)
- hct_discu_content — TEXT
- hct_discu_type — TINYINT
- hct_discu_hidden — TINYINT
- hct_discu_view_count — INT
- hct_discu_like_count — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_HOF
- hct_hof_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_team_name — VARCHAR(50)
- hct_lb_score — FLOAT
- hct_lb_send_count — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_HOME_FAQ
- hct_home_faq_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT
- hct_home_faq_title — VARCHAR(255)
- hct_home_faq_content — TEXT
- hct_home_faq_hidden — TINYINT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_HOME_NOTICE
- hct_home_notice_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_home_notice_title — VARCHAR(255)
- hct_home_notice_content — TEXT
- hct_home_notice_hidden — TINYINT
- hct_home_notice_view_count — INT
- hct_home_notice_like_count — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_INVITE_LIST
- hct_invite_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_team_leader_id — INT
- hct_team_user_id — INT
- hct_invite_status — TINYINT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_INVITE_REJECT_LIST
- hct_invite_reject_id — INT — Primary key — NOT NULL
- hct_sked_id — INT
- hct_team_leader_id — INT
- hct_team_user_id — INT
- hct_invite_reject_status — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_LEADER_BOARD
- hct_lb_id — INT — Primary key — NOT NULL
- hct_user_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_lb_score — FLOAT
- hct_lb_file_name — VARCHAR(255)
- hct_lb_file_size — VARCHAR(50)
- hct_lb_send_count — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_LIKE_LIST
- hct_like_id — INT — Primary key — NOT NULL
- hct_user_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_notice_common_id — INT
- hct_board_name — VARCHAR(50)
- hct_like_status — TINYINT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_NOTICE
- hct_notice_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_home_notice_type — VARCHAR(50)
- hct_notice_title — VARCHAR(50)
- hct_notice_content — TEXT
- hct_notice_hidden — TINYINT
- hct_view_count — INT
- hct_like_count — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_PRE_SUMBIT_LIST
- hct_rsl_id — INT — Primary key — NOT NULL
- hct_team_leader_id — INT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_REPLY_LIST
- hct_reply_id — INT — Primary key — NOT NULL
- hct_discu_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_user_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_reply_parents_id — INT
- hct_reply_content — TEXT
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_SCHEDULE
- hct_sked_id — INT — Primary key — NOT NULL
- hct_company_id — INT — Primary key — NOT NULL
- hct_admin_user_id — INT — Primary key — NOT NULL
- hct_sked_title — TEXT
- hct_sked_sub_title — TEXT
- hct_sked_summary — TEXT
- hct_sked_outline — TEXT
- hct_sked_rule — TEXT
- hct_sked_thumbnail_url — VARCHAR(255)
- hct_sked_banner_url — VARCHAR(255)
- hct_sked_organizer — VARCHAR(50)
- hct_sked_organizer_url — VARCHAR(255)
- hct_sked_host — VARCHAR(100)
- hct_sked_main_url — VARCHAR(255)
- hct_sked_metric — VARCHAR(50)
- hct_sked_start_date — DATETIME
- hct_sked_end_date — DATETIME
- hct_sked_attend_start_date — DATETIME
- hct_sked_attend_end_date — DATETIME
- hct_sked_code_start_date — DATETIME
- hct_sked_code_end_date — DATETIME
- hct_sked_rank_open_date — DATETIME
- hct_sked_reward — VARCHAR(50)
- hct_sked_agreement — TEXT
- hct_sked_apply_time — INT
- hct_sked_hackathon_type — TINYINT
- hct_humin_check_type — TINYINT
- hct_sked_survey_id — INT
- hct_slack_hook_url — VARCHAR(255)
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_SCHEDULE_SURVEY
- hct_sked_survey_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_sked_survey_title — VARCHAR(255)
- hct_sked_survey_notice — TEXT
- hct_sked_survey_content — JSON
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_UPLOAD_FILE_LIST
- hct_ufl_id — INT — Primary key — NOT NULL
- hct_sked_id — INT — Primary key — NOT NULL
- hct_notice_common_id — INT — Primary key — NOT NULL
- hct_board_name — VARCHAR(50)
- hct_file_original_name — VARCHAR(255)
- hct_file_ext — VARCHAR(50)
- hct_file_size — INT
- hct_file_url — VARCHAR(255)
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_USER
- hct_user_id — INT — Primary key — NOT NULL
- hct_user_social_id — INT — Primary key — NOT NULL
- hct_user_email — VARCHAR(50)
- hct_user_nickname — TEXT
- hct_user_social_name — TEXT
- hct_user_introduction — TEXT
- hct_user_profile_img_url — VARCHAR(255)
- hct_user_part — VARCHAR(255)
- hct_user_part_type — TINYINT
- hct_user_phone_auth — TINYINT
- hct_user_ai_hub_id — VARCHAR(255)
- hct_user_iv — VARCHAR(50)
- hct_user_integrity_value — VARCHAR(255)
- hct_user_key — VARCHAR(50)
- hct_user_enc_data — TEXT
- hct_user_privacy — TINYINT
- hct_user_privacy_time — DATETIME
- hct_user_lock — INT
- hct_user_lock_time — DATETIME
- updatedAt — DATETIME
- createdAt — DATETIME
AI_HACKATHON_USER_LEAVE_LIST
- hct_user_id — INT
- hct_user_social_id — INT
- hct_user_email — VARCHAR(50)
- hct_user_nickname — TEXT
- hct_user_social_name — TEXT
- hct_user_introduction — TEXT
- hct_user_profile_img_url — VARCHAR(255)
- hct_user_part — VARCHAR(255)
- hct_user_part_type — TINYINT
- hct_user_phone_auth — TINYINT
- hct_user_ai_hub_id — VARCHAR(255)
- hct_user_iv — VARCHAR(50)
- hct_user_key — VARCHAR(50)
- hct_user_enc_data — TEXT
- hct_user_privacy — TINYINT
- hct_user_privacy_time — DATETIME
- hct_user_lock — INT
- hct_user_lock_time — DATETIME
- updatedAt — DATETIME
- createdAt — DATETIME