ff
Tables (31)
dbo.tbl_battle
- c_no — int — NOT NULL
- c_project_no — int
- c_round_no — int
- c_team1_no — int
- c_team2_no — int
- c_date — datetime
- c_league — int
dbo.tbl_battle_base
- Key — Primary key — NOT NULL
- c_no — int — NOT NULL
- c_project_no — int
- c_round_no — int
- c_team_no — int
- c_league — int
- c_rank — int
- c_subject1 — varchar(MAX)
- c_subject1_file — varchar(200)
- c_subject2 — varchar(MAX)
- c_subject2_file — varchar(200)
- c_subject3 — varchar(MAX)
- c_subject3_file — varchar(200)
- c_date — datetime
- c_subject1_image — varchar(200)
- c_subject2_image — varchar(200)
- c_subject3_image — varchar(200)
- Column16 — varchar(50)
dbo.tbl_battle_base2
- c_no — int — NOT NULL
- c_project_no — int
- c_round_no — int
- c_team_no — int
- c_league — int
- c_rank — int
- c_subject1 — varchar(MAX)
- c_subject1_file — varchar(200)
- c_subject2 — varchar(MAX)
- c_subject2_file — varchar(200)
- c_subject3 — varchar(MAX)
- c_subject3_file — varchar(200)
- c_date — datetime
- c_subject1_image — varchar(200)
- c_subject2_image — varchar(200)
- c_subject3_image — varchar(200)
dbo.tbl_battle_point
- c_no — int — NOT NULL
- c_project_no — int
- c_season_no — int
- c_battle_no — int
- c_round_no — int
- c_team1_win — int
- c_team2_win — int
- c_pointer_type — int
- c_pointer_no — int
- c_content — varchar(MAX)
- c_date — datetime
dbo.tbl_board
- c_no — int — NOT NULL
- c_relation — int
- c_relation2 — int
- c_relation3 — int
- c_type — int
- c_member_no — int
- c_id — varchar(50)
- c_name — varchar(50)
- c_title — varchar(400)
- c_contents — text
- c_files — varchar(500)
- c_date — datetime
- c_update — datetime
- c_click — int
- c_image — varchar(100)
- c_movie — varchar(100)
- c_pass — varchar(50)
- c_part — varchar(50)
- c_temp — varchar(50)
- c_level — int
- c_ref — int
- c_step — int
- c_now — int
- c_project_no — int
- c_target — varchar(50)
- c_value — int
- c_target2 — varchar(50)
- c_value2 — int
- c_target3 — varchar(50)
- c_value3 — int
- c_jang — int
- c_file1_name — varchar(100)
- c_file2_name — varchar(100)
dbo.tbl_bug_event
- c_no — int — NOT NULL
- c_member_no — int
- c_bug1 — int
- c_bug2 — int
- c_bug3 — int
- c_bug4 — int
- c_bug5 — int
- c_date — datetime
dbo.tbl_festival_data
- c_no — int — NOT NULL
- c_year — int
- c_team_no — int
- c_member_no — int
- c_member_name — varchar(50)
- c_item_name — varchar(1000)
- c_thumbnail — varchar(300)
- c_main_type — int
- c_main — varchar(300)
- c_information — text
- c_use — int
- c_date — datetime
- c_update — datetime
- c_now — int
dbo.tbl_fund
- c_no — int — NOT NULL
- c_team_no — int
- c_festival_no — int
- c_member_type — int
- c_member_no — int
- c_fund — int
- c_exp — text
- c_use — int
- c_date — datetime
- c_year — int
- c_team_type — int
dbo.tbl_growup
- c_no — int — NOT NULL
- c_project_no — int
- c_gu_no — int
- c_team_no — int
- c_member_no — int
- c_member_type — int
- c_count — int
- c_use — int
- c_date — datetime
- c_text — varchar(MAX)
- c_file — varchar(300)
- c_a_date — datetime
- c_a_date2 — datetime
dbo.tbl_image
- c_no — int — NOT NULL
- c_relation — int
- c_title — varchar(100)
- c_file — varchar(100)
- c_text — varchar(500)
- c_text2 — varchar(500)
- c_link — varchar(500)
- c_target — varchar(50)
- c_use — int
- c_order — int
- c_date — datetime
dbo.tbl_manager
- c_no — int — NOT NULL
- c_id — nvarchar(20)
- c_pass — nvarchar(20)
- c_name — nvarchar(50)
- c_level — int
- c_region — int
dbo.tbl_member
- c_no — int — NOT NULL
- c_id — varchar(50)
- c_pass — varchar(300)
- c_name — varchar(50)
- c_email — varchar(200)
- c_phone — varchar(20)
- c_phone2 — varchar(200)
- c_date — datetime
- c_add — varchar(500)
- c_email_license — int
- c_sosok — varchar(100)
- c_position — varchar(100)
- c_cafe — int
- c_teach — int
- c_ex1 — varchar(100)
- c_ex2 — varchar(100)
- c_ex3 — varchar(100)
- c_pass2 — varchar(300)
- c_festival — int
- c_recommend — varchar(50)
- c_kakao — varchar(300)
- c_naver — varchar(300)
- c_out — int
- c_use_yn — char(1)
- festival_recommend_date — datetime
- recommend_year — varchar(50)
dbo.tbl_mentor_relation
- c_no — int — NOT NULL
- c_relation — int
- c_mentor — int
- c_team_no — int
dbo.tbl_menu
- c_no — int — Primary key — NOT NULL
- c_home — int
- c_up_no — int
- c_relation — int
- c_relation2 — int
- c_level — int
- c_order — int
- c_type — int
- c_name — varchar(300)
- c_content — varchar(500)
- c_exp — text
- c_use — int
dbo.tbl_project
- c_no — int — NOT NULL
- c_year — int
- c_relation — int
- c_name — varchar(200)
- c_s_date — datetime
- c_e_date — datetime
- c_now — int
- c_use — int
- c_date — datetime
dbo.tbl_puzzle
- c_no — int — NOT NULL
- c_year — int
- c_puzzle_no — int
- c_order — int
- c_garo — int
- c_sero — int
- c_member_no — int
- c_member_id — varchar(50)
- c_content — text
- c_point — int
- c_use — int
- c_date — datetime
- c_choice — int
dbo.tbl_survey
- c_no — int — NOT NULL
- c_name — varchar(200)
- c_date — datetime
- c_use — int
dbo.tbl_survey_answer
- c_no — int — NOT NULL
- c_problem — int
- c_name — varchar(1000)
- c_order — int
- c_type — int
dbo.tbl_survey_person
- c_no — int — NOT NULL
- c_project_no — int
- c_survey_no — int
- c_member — int
- c_now — int
- c_date — datetime
- c_ok_date — datetime
- c_email — varchar(100)
- c_phone — varchar(20)
- c_sosok — varchar(100)
- c_name — varchar(100)
- c_rand — varchar(50)
- c_team_name — varchar(300)
- c_univ — varchar(200)
- c_position — varchar(200)
dbo.tbl_survey_problem
- c_no — int — NOT NULL
- c_survey_no — int
- c_name — varchar(2000)
- c_type — int
- c_order — int
- c_left — varchar(50)
- c_mid — varchar(50)
- c_right — varchar(50)
- c_size — int
dbo.tbl_survey_project
- c_no — int — NOT NULL
- c_project_no — int
- c_name — varchar(500)
- c_target — varchar(100)
- c_exp — text
- c_survey_no — int
- c_date — datetime
- c_s_date — datetime
- c_e_date — datetime
- c_now — int
- c_type — int
dbo.tbl_survey_result
- c_no — int — NOT NULL
- c_project_no — int
- c_person_no — int
- c_survey_no — int
- c_problem_no — int
- c_answer_no — int
- c_text — text
dbo.tbl_team
- c_no — int — NOT NULL
- c_project_no — int
- c_region — int
- c_member_no — int
- c_school_type — int
- c_part — int
- c_team_name — varchar(200)
- c_logo — varchar(100)
- c_item_name — varchar(300)
- c_item_exp — varchar(300)
- c_item_part — varchar(50)
- c_4d_tech — varchar(50)
- c_emotion — varchar(500)
- c_char — varchar(500)
- c_market — varchar(500)
- c_com — int
- c_com_kind — varchar(200)
- c_com_no — varchar(30)
- c_com_date — datetime
- c_com_paper — varchar(100)
- c_manager_name — varchar(50)
- c_manager_school — varchar(50)
- c_manager_part — varchar(100)
- c_manager_phone — varchar(20)
- c_manager_phone2 — varchar(20)
- c_manager_email — varchar(200)
- c_file1 — varchar(100)
- c_file2 — varchar(100)
- c_file3 — varchar(100)
- c_file4 — varchar(100)
- c_file5 — varchar(100)
- c_file6 — varchar(100)
- c_temp — text
- c_temp2 — text
- c_use — int
- c_date — datetime
- c_update — datetime
- c_point1_result_region — int
- c_point1_point_region — int
- c_point2 — int
- c_point2_order — int
- c_u300 — int
- c_u300_order — int
- c_top — int
- c_top_order — int
- c_change — int
- c_growup — int
- c_history1 — varchar(300)
- c_history2 — varchar(300)
- c_history3 — varchar(300)
- c_file7 — varchar(100)
- c_file8 — varchar(100)
- c_file9 — varchar(50)
- c_file10 — varchar(200)
- c_point2_sub — int
- c_point2_sub_order — int
- c_festival — int
- c_festival_type — int
- c_demo1 — int
- c_demo2 — int
- … +9
dbo.tbl_team_member
- c_no — int — NOT NULL
- c_project_no — int
- c_team_no — int
- c_member_no — int
- c_jang — int
- c_name — varchar(50)
- c_sex — varchar(10)
- c_phone — varchar(100)
- c_email — varchar(100)
- c_study_type — int
- c_grade — varchar(50)
- c_major — varchar(30)
- c_school_name — varchar(100)
- c_region — varchar(50)
- c_school_type — varchar(50)
- c_use — int
- c_date — datetime
- c_update — datetime
- c_majority — varchar(200)
- c_birth — varchar(30)
dbo.tbl_temp_result
- c_no — int — NOT NULL
- c_project_no — int
- c_relation — int
- c_u300 — int
- c_tester — int
- c_point — varchar(200)
- c_sum — int
- c_exp — varchar(MAX)
- c_ok — int
- c_date — datetime
- c_update — datetime
- c_pass — int
- c_exp2 — varchar(MAX)
- c_growup1_no — int
- c_growup2_no — int
dbo.tbl_temp_tester
- c_no — int — NOT NULL
- c_project_no — int
- c_relation — int
- c_id — varchar(20)
- c_pass — varchar(20)
- c_name — varchar(20)
- c_sosok — varchar(50)
- c_part — int
- c_part2 — int
- c_jang — int
- c_date — datetime
- c_last_date — datetime
dbo.tbl_univ
- c_no — int — NOT NULL
- c_name — varchar(100)
- c_region — int
- c_sido — int
- c_use — int
- univ_gubun — varchar(100)
- univ_flag — varchar(100)
- univ_sigungu — varchar(100)
- c_region_nm — varchar(100)
dbo.tbl_visit
- c_no — int — NOT NULL
- c_year — int
- c_month — int
- c_relation — int
- c_relation2 — int
- c_visit — int
dbo.tbl_vote
- c_no — int — NOT NULL
- c_member_no — int
- logo_vote — varchar(50)
- c_date — datetime
dbo.tbl_vote_count
- c_no — int — NOT NULL
- c_member_no — int
- vote_count — int
- c_date — datetime
dbo.tbl_work
- c_no — int — NOT NULL
- c_relation — int
- c_team_no — int
- c_member_no — int
- c_team_name — varchar(200)
- c_jang — int
- c_name — varchar(50)
- c_text — varchar(3000)
- c_file1 — varchar(200)
- c_file2 — varchar(200)
- c_date — datetime