생성1
테이블 (52)
QUestionDto
- id — int(11) — 기본 키 — NOT NULL
- question_content — varchar(2000)
- created_at — datetime
Question
- id — int(11) — 기본 키 — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- created_at — datetime
le_funding_news
- id — int(11) — 기본 키 — NOT NULL
- funding_id — int(11) — NOT NULL
- title — varchar(100)
- content — text
- created_at — datetime
le_funding_participants
- id — int(11) — 기본 키 — NOT NULL
- funding_id — int(11) — NOT NULL
- student_id — int(11) — NOT NULL
- participated_at — datetime
le_funding_qna
- id — int(11) — 기본 키 — NOT NULL
- funding_id — int(11) — NOT NULL
- student_id — int(11) — NOT NULL
- question — text
- created_at — datetime
- is_private — tinyint(1)
- answer — text
- answered_at — datetime
- is_answer_deleted — tinyint(1)
le_funding_rejection_reason
- id — int(11) — 기본 키 — NOT NULL
- funding_id — int(11)
- student_id — int(11)
- reason — varchar(250)
- created_at — datetime
le_lecture
- id — int(11) — 기본 키 — NOT NULL
- lecturer_id — int(11)
- title — varchar(50)
- tuition_fee — int(11)
- exam_ratio — int(11)
- assignment_ratio — int(11)
- attendence_ratio — int(11)
- syllabus_address — varchar(1000)
- created_at — datetime
le_lecture_article
- id — int(11) — 기본 키 — NOT NULL
- lecture_section_id — int(11)
- type — varchar(20)
- title — varchar(50)
- content — varchar(3000)
- created_at — datetime
- read_count — int(11)
le_lecture_evaluation_answer
- id — int(11) — 기본 키 — NOT NULL
- lecture_evaluation_question_id — int(11)
- enrollment_id — int(11)
- score — int(11)
- content — varchar(2000)
- created_at — datetime
le_lecture_evaluation_question
- id — int(11) — 기본 키 — NOT NULL
- lecture_id — int(11)
- number — int(11)
- content — varchar(200)
- created_at — datetime
le_lecture_section
- id — int(11) — 기본 키 — NOT NULL
- lecture_id — int(11)
- classification — varchar(10)
- max_enrollment — int(11)
- total_session — int(11)
- start_date — date
- end_date — date
- created_at — datetime
le_lecture_time
- id — int(11) — 기본 키 — NOT NULL
- lecture_section_id — int(11)
- day_of_week — varchar(3)
- start_time — time
- end_time — time
- classroom_id — varchar(50)
- created_at — datetime
le_lecturer
- id — int(11) — 기본 키 — NOT NULL
- relation_id — int(11)
- name — varchar(20)
- gender — varchar(1)
- birth — date
- email — varchar(50)
- phone — varchar(30)
- created_at — datetime
le_market_article
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- board_category — varchar(500)
- title — varchar(100)
- content — varchar(5000)
- image_address — varchar(5000)
- read_count — int(11)
- created_at — datetime
le_market_comment
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- student_id — int(11)
- content — varchar(5000)
- created_at — datetime
le_market_image
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- file_path — varchar(3000)
- file_type — varchar(200)
- uploaded_at — datetime
le_market_like
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- sale_article_id — int(11)
- created_at — datetime
le_market_message
- id — int(11) — 기본 키 — NOT NULL
- sale_article_id — int(11)
- sender_id — int(11)
- receiver_id — int(11)
- content — varchar(2000)
- created_at — datetime
- sender_status — tinyint(1)
- receiver_status — tinyint(1)
le_market_trade_article
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- category — varchar(100)
- image_address — varchar(5000)
- title — varchar(100)
- content — varchar(5000)
- status — varchar(50)
- price — int(11)
- created_at — datetime
- read_count — int(11)
le_market_trade_image
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- location — varchar(1000)
- original_filename — varchar(1000)
- created_at — datetime
le_notice
- id — int(11) — 기본 키 — NOT NULL
- admin_id — int(11)
- title — varchar(50)
- content — varchar(5000)
- is_fixed — tinyint(1)
- read_count — int(11)
- created_at — datetime
le_notice_coment
- id — int(11) — 기본 키 — NOT NULL
- notice_id — int(11)
- student_id — int(11)
- content — varchar(300)
- created_at — datetime
le_notice_comment
- id — int(11) — 기본 키 — NOT NULL
- notice_id — int(11)
- admin_id — int(11)
- content — varchar(300)
- created_at — datetime
le_payment
- id — int(11) — 기본 키 — NOT NULL
- enrollment_id — int(11)
- bank_name — varchar(20)
- bank_account — varchar(50)
- status — varchar(10)
- paid_at — datetime
- created_at — datetime
le_produce_article
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- board_category — varchar(500)
- title — varchar(100)
- content — varchar(5000)
- image_address — varchar(5000)
- view_count — int(11)
- created_at — datetime
le_produce_comment
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- student_id — int(11)
- content — varchar(5000)
- created_at — datetime
le_produce_image
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- file_path — varchar(3000)
- file_type — varchar(200)
- uploaded_at — datetime
le_produce_like
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- sale_article_id — int(11)
- created_at — datetime
le_produce_message
- id — int(11) — 기본 키 — NOT NULL
- sale_article_id — int(11)
- sender_id — int(11)
- receiver_id — int(11)
- content — varchar(2000)
- created_at — datetime
- sender_status — tinyint(1)
- receiver_status — tinyint(1)
le_produce_sale_article
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- category — varchar(100)
- status — varchar(50)
- price — int(11)
- address — varchar(3000)
- content — varchar(5000)
- image_address — varchar(5000)
- created_at — datetime
le_produce_sale_image
- id — int(11) — 기본 키 — NOT NULL
- article_id — int(11)
- file_path — varchar(3000)
- file_type — varchar(200)
- uploaded_at — datetime
le_question
- id — int(11) — 기본 키 — NOT NULL
- exam_id — int(11)
- question_number — int(11)
- question_content — varchar(2000)
- answer — varchar(30)
- score — int(11)
- created_at — datetime
le_refund
- id — int(11) — 기본 키 — NOT NULL
- payment_id — int(11)
- bank_name — varchar(20)
- bank_account — varchar(50)
- reason — varchar(255)
- status — varchar(10)
- processed_at — datetime
- created_at — datetime
le_student
- id — int(11) — 기본 키 — NOT NULL
- relation_id — int(11)
- name — varchar(20)
- gender — varchar(1)
- phone — varchar(30)
- address — varchar(500)
- birth — datetime
- email — varchar(30)
- created_at — datetime
mind_postit
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- question_id — int(11)
- nickname — varchar(30)
- memo_comment — varchar(2000)
- color — varchar(2000)
- is_anonymous — tinyint(1)
- is_public — tinyint(1)
- created_at — datetime
notice
- notice_id — int(11) — 기본 키 — NOT NULL
- admin_id — int(11) — NOT NULL
- title — varchar(200)
- description — text
- image — varchar(255)
- created_at — datetime
- updated_at — datetime
professor
- id — int(11) — 기본 키 — NOT NULL
- department_id — int(11)
- professor_no — varchar(20)
- password — varchar(50)
- name — varchar(20)
- registration_id — varchar(16)
- birth — date
- gender — varchar(1)
- email — varchar(50)
- phone — varchar(20)
- address — varchar(50)
- id_photo_loc — varchar(5000)
- entrance_date — date
- created_at — datetime
recommend_link_category
- id — int(11) — 기본 키 — NOT NULL
- name — varchar(50)
- created_at — datetime
residence_application
- id — int(11) — 기본 키 — NOT NULL
- student_id — int(11)
- room_recruit_id — int(11)
- address — varchar(200)
- requirement — varchar(500)
- application_status — varchar(50)
- application_passed — varchar(50)
- gpa — double
- gpa_score — int(11)
- created_at — datetime
residence_application_cancel
- id — int(11) — 기본 키 — NOT NULL
- application_id — int(11)
- status — varchar(100)
- reason — varchar(500)
- created_at — datetime
residence_application_schedule
- id — int(11) — 기본 키 — NOT NULL
- administrator_id — int(11)
- year — int(11)
- term — varchar(50)
- name — varchar(200)
- stay_start_date — datetime
- stay_end_date — datetime
- application_start_date — datetime
- application_end_date — datetime
- cancel_stay_start_date — datetime
- cancel_stay_end_date — datetime
- application_result_start_date — datetime
- application_result_end_date — datetime
- assignment_result_start_date — datetime
- assignment_result_end_date — datetime
- created_at — datetime
residence_article
- id — int(11) — 기본 키 — NOT NULL
- category_id — int(11)
- content — varchar(3000)
- created_at — datetime
residence_building
- id — int(11) — 기본 키 — NOT NULL
- administrator_id — int(11)
- name — varchar(100)
- address — varchar(200)
- ground_floors — int(11)
- basement_floors — int(11)
- created_at — datetime
residence_building_image
- id — int(11) — 기본 키 — NOT NULL
- building_id — int(11)
- image_loc — varchar(1000)
- created_at — datetime
residence_community_all_article_log
- id — int(11) — 기본 키 — NOT NULL
- residence_community_board_id — int(11)
- residence_community_article_id — int(11)
- residence_community_user_id — int(11)
- created_at — datetime
residence_community_all_comment_on_article_log
- id — int(11) — 기본 키 — NOT NULL
- residence_community_board_id — int(11)
- residence_community_article_id — int(11)
- residence_community_comment_id — int(11)
- residence_community_user_id — int(11)
- created_at — datetime
residence_community_article_image_info
- id — int(11) — 기본 키 — NOT NULL
- community_article_info_id — int(11)
- location — varchar(2000)
- created_at — datetime
residence_community_article_info_of_1st_board
- id — int(11) — 기본 키 — NOT NULL
- residence_community_board_id — int(11)
- residence_community_user_id — int(11)
- viewed_count — int(11)
- created_at — datetime
- edited_at — datetime
- title — varchar(500)
- content — varchar(4000)
- is_title_public_on_main_page — varchar(1)
- is_user_residence_info_public — varchar(1)
- is_profile_of_article_writer_public — varchar(1)
residence_community_article_info_of_2nd_board
- id — int(11) — 기본 키 — NOT NULL
- residence_community_board_id — int(11)
- residence_community_user_id — int(11)
- viewed_count — int(11)
- created_at — datetime
- edited_at — datetime
- title — varchar(500)
- content — varchar(4000)
- is_title_public_on_main_page — varchar(1)
- is_user_residence_info_public — varchar(1)
- is_profile_of_article_writer_public — varchar(1)
- are_items_registered — varchar(1)
- is_sharing_ended — varchar(1)
residence_community_article_info_of_3rd_board
- id — int(11) — 기본 키 — NOT NULL
- residence_community_board_id — int(11)
- residence_community_user_id — int(11)
- viewed_count — int(11)
- created_at — datetime
- edited_at — datetime
- title — varchar(500)
- content — varchar(4000)
- is_title_public_on_main_page — varchar(1)
- is_user_residence_info_public — varchar(1)
- is_profile_of_article_writer_public — varchar(1)
- is_member_recruiting_info_registered — varchar(1)
- is_member_recruiting_ended — varchar(1)
residence_community_board_info
- id — int(11) — 기본 키 — NOT NULL
- name — varchar(200)
- explanation — varchar(400)
- created_at — datetime
residence_community_comment_info_of_1st_board
- id — int(11) — 기본 키 — NOT NULL
- comment_of_comment_id — int(11)
- residence_community_article_id — int(11)
- residence_community_user_id — int(11)
- content — varchar(2000)
- created_at — datetime
- edited_at — datetime
- is_user_residence_info_public — varchar(1)
- is_profile_of_comment_writer_public — varchar(1)