readme
Tables (11)
Election (선거 공지)
- Index (Key) — INT(11) — Primary key — NOT NULL
- Election_img (img) — VARCHAR(255)
- College (college) — VARCHAR(255)
- Department (department) — VARCHAR(255)
Election_Result (선거 결과)
- Index (Key) — INT(11) — Primary key — NOT NULL
- College (college) — VARCHAR(255)
- Department (department) — VARCHAR(255)
- collegeId (단과 번호) — INT(11)
- deptId (학과 번호) — INT(11)
- Election_total (total) — INT(11)
- Candidate_1 (C1) — INT(11)
- Candidate_2 (C2) — INT(11)
- Candidate_3 (C3) — INT(11)
- total_voter (유권자) — INT(11)
Fulfilled_Pledge (이행한 공약 리스트)
- Index (Key) — INT(11) — Primary key — NOT NULL
- College (college) — VARCHAR(255)
- Department (department) — VARCAHR(255)
- collegeId (단과 번호) — INT(11)
- deptId (학과 번호) — INT(11)
- img — VARCAHR(255)
- Pledge_title (title) — VARCHAR(255)
- pledge_content (content) — VARCHAR(255)
- Fulfilled_Date (date) — DATETIME
- writer (작성자) — VARCHAR(255)
- time (작성 시간) — DATETIME
Member (Untitled)
- Index (Key) — INT(11) — Primary key — NOT NULL
- ID (id) — VARCHAR(255)
- PassWord (pwd) — VARCHAR(255)
- college — VARCHAR(255)
- Department (department) — VARCHAR(255)
- Student_number (number) — INT(11)
- Phone_num (phone) — VARCHAR(255)
- Authority (authority) — INT(11)
NOTICE (공지사항)
- Index (Key) — INT(11) — Primary key — NOT NULL
- Img (img) — VARCHAR(255)
- Attachment (attachment) — VARCHAR(255)
- Article_title (title) — VARCHAR(255)
- Article_content (content) — TEXT
- Article_writer (writer) — VARCHAR(255)
- Article_view (views) — INT(11)
- Article_time (time) — DATETIME
candidate (입후보)
- Index (Key) — INT(11) — Primary key — NOT NULL
- Number (기호 번호) — INT
- img (후보자 사진) — VARCHAR(255)
- name (후보자 이름) — VARCHAR(255)
- collegeId (단과 번호) — VARCHAR(255)
- deptId (학과 번호) — VARCHAR(255)
- College (college) — VARCHAR(255)
- Department (department) — VARCHAR(255)
- grade (학번) — INT(11)
- career (경력) — VARCHAR(255)
- Field
- Election_pledge (pledge) — VARCHAR(255)
codeName (코드명)
- collegeId (단과번호) — INT(11) — Foreign key → candidate.Index — NOT NULL
- deptId (학과번호) — INT(11) — Foreign key → Election_Result.Index — NOT NULL
codeTable (단과,학과 코드번호)
- index (Key) — INT(11) — Primary key — NOT NULL
- collegeId (단과번호) — INT(11)
- deptId (학과번호) — INT(11)
- collegeName (단과 이름) — VARCHAR(255)
- deptName (학과 이름) — VARCHAR(255)
council (학생회 페이지)
- Index (Key) — INT(11) — Primary key — NOT NULL
- Img (img) — VARCHAR(255)
- collegeId (단과 번호) — VARCHAR(255)
- deptId (학과 번호) — VARCHAR(255)
- Activity_title (title) — VARCHAR(255)
- Activity_content (content) — TEXT
- Activity_writer (writer) — VARCHAR(255)
- Activity_time (activityTime) — DATETIME
- Article_time (articleTime) — DATETIME
- Article_view (view) — INT(11)
pledge_list (전체 공약 리스트)
- Index (Key) — INT(11) — Primary key — NOT NULL
- collegeId (단과 번호) — INT(11)
- deptId (학과 번호) — INT(11)
- Pledge_title (title) — VARCHAR(255)
- pledge_content (content) — VARCHAR(255)
pledge_rate (공약 이행률)
- Index (Key) — INT(11) — Primary key — NOT NULL
- collegeId (단과 번호) — INT(11)
- deptId (학과 번호) — INT(11)
- Total_Pledge (total) — INT(11)
- Fulfilled_Pledge (fulfilled) — INT(11)
- Fulfillement_rate (rate) — INT(11)