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