생성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)