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)