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