실험본
테이블 (53)
Category
- id — INT — NOT NULL
- category_name — VARCHAR(100)
Comment
- id — INT — NOT NULL
- user_id — INT — NOT NULL
- article_id — INT — NOT NULL
- content — VARCHAR(5000)
- created_at — TIMESTAMP
CopyOfUntitled26
- id — INT — NOT NULL
- category_name — VARCHAR(100)
- sub_category_id — INT
- sub_category_name — VARCHAR(100)
Post
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- category_id — VARCHAR(300) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- view_count — INT
- title — VARCHAR(100)
- content — VARCHAR(5000)
Untitled
- Key — VARCHAR(255) — NOT NULL
- Key2 — VARCHAR(255) — NOT NULL
- industry — VARCHAR
- employees — INT
- type — VARCHAR
- business — VARCHAR
- CEO — VARCHAR
- website — VARCHAR
- address — VARCHAR
- revenue — VARCHAR?
- capital — VARCHAR
- starting_salary — VARCHAR
- thumbnail — VARCHAR(200)
Untitled2
- id — INT — NOT NULL
- 이름? — VARCHAR
Untitled3
- Key — VARCHAR(255) — NOT NULL
Untitled6
- id — INT — NOT NULL
- time — INT
awards
- Key — VARCHAR(255) — NOT NULL
- name — VARCHAR
- Field — VARCHAR
- Field2 — DATETIME
- resume_id — INT — NOT NULL
career_program_attaches
- id — INT — NOT NULL
- program_id — INT — NOT NULL
- attachment — VARCHAR
- created_at — DATETIME
career_program_images
- id — INT — NOT NULL
- program_id — INT — NOT NULL
- image — VARCHAR
- created_at — DATETIME
career_programs
- id — INT — NOT NULL
- program_title — VARCHAR
- program_content — VARCHAR
- created_at — DATETIME
- host — VARCHAR
- eligibility — INT
- capacity — INT
- enrollment_start — DATETIME
- enrollment_end — DATETIME
- event_date — DATETIME
- application_methods — VARCHAR
categories
- id — INT — NOT NULL
- program_id — INT — NOT NULL
- category_id — INT — NOT NULL
certifications
- Key — VARCHAR(255) — NOT NULL
- name — VARCHAR
- Field — VARCHAR
- Field2 — DATETIME
- Field3 — INT
- resume_id — INT — NOT NULL
contest_attaches
- id — INT — NOT NULL
- contest_id — INT — NOT NULL
- file_name — VARCHAR(300)
- file_url — VARCHAR(500)
- uploaded_at — TIMESTAMP
contest_bookmarks
- id — INT — NOT NULL
- contest_id — INT — NOT NULL
- scrap_date — DATETIME
- 아이디 — INT — NOT NULL
contest_images
- id — INT — NOT NULL
- contest_id — INT — NOT NULL
- image_url — VARCHAR(500)
- uploaded_at — TIMESTAMP
contests
- id — INT — NOT NULL
- id2 — INT — NOT NULL
- 아이디 — INT — NOT NULL
- title — VARCHAR(300)
- description — VARCHAR(2000)
- start_day — DATETIME
- end_day — DATETIME
- organizer — VARCHAR(300)
- category_id — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
counsel
- id — INT — NOT NULL
- staff — INT — NOT NULL
- student_id — INT — NOT NULL
- resume_id — INT — NOT NULL
- content — VARCHAR(255)
- is_counsel — VARCHAR(1)
- created_at — DATE
counsel_available_date
- id — INT — NOT NULL
- staff_id — INT — NOT NULL
- date — DATE
- blocked — VARCHAR
counsel_available_time
- id — INT — NOT NULL
- id2 — INT — NOT NULL
- date — DATE
- time_id — INT — NOT NULL
- blocked — VARCHAR
counsel_schedule
- id — INT — NOT NULL
- counsel_id — INT — NOT NULL
- date — DATETIME
- available_person — INT
- is_schedule — VARCHAR
- created_at — DATETIME
essay
- Key — VARCHAR(255) — NOT NULL
- content — VARCHAR(5000)
- id — INT — NOT NULL
- title — VARCHAR(100)
experience_details
- Key — VARCHAR(255) — NOT NULL
- Key2 — VARCHAR(255) — NOT NULL
- Field — VARCHAR
- Field2 — VARCHAR
- Field3 — VARCHAR
- Field4 — INT
- Field5 — VARCHAR
- Field8 — VARCHAR
- Field6 — DATETIME
- Field7 — DATETIME
job_status
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- isEmployed — VARCHAR(1)
- isStartUp — VARCHAR(1)
key_skills
- id — INT — NOT NULL
- program_id — INT — NOT NULL
- skills_id — INT — NOT NULL
language_scores
- Key — VARCHAR(255) — NOT NULL
- name — VARCHAR
- Field2 — DATETIME
- Field3 — VARCHAR
- resume_id — INT — NOT NULL
portfolio
- id — INT — NOT NULL
- link — VARCHAR(200)
- resume_id — INT — NOT NULL
program_attendance
- id — INT — NOT NULL
- program_signups_id — INT — NOT NULL
- attendance — BOOLEAN
- updated_at — DATETIME
program_bookmarks
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- program_id — INT — NOT NULL
- created_at — DATETIME
program_categories
- id — INT — NOT NULL
- categories — VARCHAR
program_key_skills
- id — INT — NOT NULL
- skills — VARCHAR
program_signups
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- program_id — INT — NOT NULL
- created_at — DATETIME
- attendance — CHAR(1)
program_surveys
- id — INT — NOT NULL
- program_signups_id — INT — NOT NULL
- questions_id — INT — NOT NULL
- ratings — INT
- created_at — DATETIME
recommand_company
- id — INT — NOT NULL
- solution_id — INT — NOT NULL
- id2 — INT — NOT NULL
recommand_program
- id — INT — NOT NULL
- solution_id — INT — NOT NULL
- id2 — INT — NOT NULL
- id22 — INT — NOT NULL
recruit
- id — INT — NOT NULL
- 제목 — VARCHAR
- company — VARCHAR
- Field — VARCHAR
- Field4 — VARCHAR
- Field5 — VARCHAR
- content — VARCHAR
- Field6 — DATETIME
- created_at — DATETIME
- interview_place — VARCHAR(100)
- view_count — INT
- interview_date — DATETIME
- region — VARCHAR
- Field2 — VARCHAR
- Key2 — INT — NOT NULL
recruit_application
- Key — VARCHAR(255) — NOT NULL
- resume_id — INT — NOT NULL
- recruit_id — INT — NOT NULL
- status — VARCHAR(10)
recruit_attaches
- id — INT — NOT NULL
- attatchement — VARCHAR
- notice_id — INT — NOT NULL
recruit_bookmarks
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- notice_id — INT — NOT NULL
- created_at — DATETIME
recruit_images
- id — INT — NOT NULL
- link — VARCHAR
- notice_id — INT — NOT NULL
recruit_interview
- Key — VARCHAR(255) — NOT NULL
- application_id — INT — NOT NULL
- status — VARCHAR(10)
- time_id — INT — NOT NULL
rental_available_date
- id — INT — NOT NULL
- space_id — INT — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
rental_office
- rental_office_id — INT — NOT NULL
- student_id — INT — NOT NULL
- space_id — INT — NOT NULL
- rental_available_date — INT — NOT NULL
rental_space
- space_id — INT — NOT NULL
- space_img_id — INT — NOT NULL
- name — VARCHAR
- address — VARCHAR
- capacity — INT
- created_at — DATETIME
rental_space_property
- rental_property_id — INT — NOT NULL
- space_id — INT — NOT NULL
- property — VARCHAR
resume
- id — INT — NOT NULL
- student_id — INT — NOT NULL
- created_at — DATETIME
- title — VARCHAR(100)
servey_questions
- id — INT — NOT NULL
- questions — VARCHAR
- created_at — DATETIME
solution
- Id — INT — NOT NULL
- counsel_id — INT — NOT NULL
- solution_content — VARCHAR
- secret_councel_content — VARCHAR
- created_at — DATE
staff
- id — INT — NOT NULL
- name — VARCHAR(255)
student
- 아이디 — INT — NOT NULL
- SID — INT
- 이름 — VARCHAR(20)
- 성별 — VARCHAR(1)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
survey
- id — INT — NOT NULL
- counsel_id — INT — NOT NULL
- star_rated — INT
- review — VARCHAR(4000)
- created_at — DATE
work_experience
- Key — VARCHAR(255) — NOT NULL
- Field — VARCHAR
- Field2 — INT
- resume_id — INT — NOT NULL