erd

Tables (10)

Admin

  • Field (admin_domain) — VARCHAR(50)
  • Field2 (admin_pagename) — VARCHAR(30)
  • Field3 (admin_email) — VARCHAR(50)
  • Field4 (admin_phonenum) — VARCHAR(20)
  • Field5 (admin_addresss) — VARCHAR(50)

Company

  • Key (com_ID) — INT(30) — Primary key — NOT NULL
  • Field (com_num) — INT(20)
  • Field (com_name) — VARCHAR(30)
  • Field (com_representative) — VARCHAR(30)
  • Field4 (com_phonenum) — VARCHAR(20)
  • Field5 (com_email) — VARCHAR(50)
  • Field6 (com_identification) — VARCHAR(20)
  • Field7 (com_password) — VARCHAR(20)
  • Field (com_sector) — VARCHAR(30)
  • Field2 (com_content) — VARCHAR(250)
  • Field3 (com_annualsales) — Int(20)
  • Field4 (com_address) — VARCHAR(50)

CompanyBoard

  • Key (cb_num) — INT(30) — Primary key — NOT NULL
  • Field (cb_sector) — VARCHAR(30)
  • Field2 (cb_title) — VARCHAR(50)
  • Field3 (cb_content) — Text
  • Key (com_ID) — INT(30) — Foreign key → Company.Key — NOT NULL

Project

  • Key (project_ID) — INT(30) — Primary key — NOT NULL
  • Field (projcet_title) — VARCHAR(50)
  • Field2 (project_ongoing) — VARCHAR(20)
  • Key (com_ID) — INT(30) — Foreign key → Company.Key — NOT NULL

Schedule

  • Key (sch_ID) — INT(30) — Primary key — NOT NULL
  • Field (sch_content) — VARCHAR(250)
  • Field2 (sch_startdate) — DATE
  • Field3 (sch_enddate) — DATE
  • Field (sch_status) — VARCHAR(20)
  • Key (std_ID) — INT(30) — Foreign key → Student.Key — NOT NULL

Student

  • Key (std_ID) — INT(30) — Primary key — NOT NULL
  • Field (stu_studentID) — INT(9)
  • Field (std_name) — VARCHAR(30)
  • Field (std_department) — VARCHAR(30)
  • Field (std_email) — VARCHAR(50)
  • Field (stu_phonenum) — VARCHAR(20)
  • Field (stu_address) — VARCHAR(50)
  • Field (std_identification) — VARCHAR(20)
  • Field (std_password) — VARCHAR(20)
  • Field (std_interest1) — VARCHAR(30) — NOT NULL
  • Field (std_interest2) — VARCHAR(30)
  • Field (std_interest3) — VARCHAR(30)
  • Field (std_interest4) — VARCHAR(30)
  • Field (std_interest5) — VARCHAR(30)
  • Field (std_interest6) — VARCHAR(30)
  • Key (team_ID) — INT(30) — Foreign key → Team.Key — NOT NULL

Tb_attach

  • Key (tba_ID) — INT(30) — Primary key — NOT NULL
  • Field (tba_uploadpath) — VARCHAR(200)
  • Field2 (tba_filename) — VARCHAR(30)
  • Field3 (tba_filetype) — VARCHAR(10)
  • Key (tbc_ID) — INT(30) — Foreign key → TeamBoardContent.Key — NOT NULL

Team

  • Key (team_ID) — INT(30) — Primary key — NOT NULL
  • Field (team_name) — VARCHAR(30)
  • Field (team_subject) — VARCHAR(100)
  • Key (project_ID) — INT(30) — Foreign key → Project.Key — NOT NULL

TeamBoard

  • Key (tb_ID) — INT(30) — Primary key — NOT NULL
  • Field (tb_name) — VARCHAR(30)
  • Field2 (tb_authority) — VARCHAR(20)

TeamBoardContent

  • Key (tbc_ID) — INT(30) — Primary key — NOT NULL
  • Field (tbc_title) — VARCHAR(50)
  • Field2 (tbc_content) — Text
  • Field3 (tbc_date) — DATE
  • Field4 (tbc_writer) — VARCHAR(30)
  • Key (team_ID) — INT(30) — Foreign key → Team.Key — NOT NULL
  • Key (tb_ID) — INT(30) — Foreign key → TeamBoard.Key — NOT NULL