졸업 프로젝트 ERD2
테이블 (7)
Company
- Key (com_keyId) — number — 기본 키 — NOT NULL
- Field (com_num)
- Field (com_name) — varchar(100)
- Field (com_representive) — varchar(100)
- Field (com_cellphone) — number
- Field (com_email) — varchar(100)
- Field (com_identification) — varchar(50)
- Field (com_password) — varchar(50)
- Field (com_sector) — varchar
- Field (com_product) — text
- Field (com_annualSales) — number
- Key (com_team) — number — 외래 키 → Team.Key — NOT NULL
Schedule
- Key (sch_num) — number — 기본 키 — NOT NULL
- Field (sch_content) — text
- Field2 (sch_enddate) — date
- sch (sch_complete) — boolean
- Key (sch_manager) — number — 외래 키 → Student.Key — NOT NULL
Student
- Key (std_keyId) — number — 기본 키 — NOT NULL
- Field (std_studentId) — number
- Field (std_name) — varchar(100)
- Field (std_department) — varchar(50)
- Field (std_email) — varchar(100)
- Field (std_phonenum) — number
- Field (std_identification) — varchar(50)
- Field (std_password) — varchar(50)
- Field (std_interest1) — varchar(50)
- Field2 (std_interest2) — varchar(50)
- Field3 (std_interest3) — varchar(50)
- Field4 (std_interest4) — varchar(50)
- Field5 (std_interest5) — varchar(50)
- Field6 (std_interest6) — varchar(50)
- Key (std_team) — number — 외래 키 → Team.Key — NOT NULL
Team
- Key (team_keyId) — number — 기본 키 — NOT NULL
- Field (team_subject) — text
companyBoard (ComBoard)
- Key (cb_num) — number — 기본 키 — NOT NULL
- Field (cb_field) — varchar
- Field2 (cb_title) — varchar
- Field3 (cb_content) — text
- Key (cb_writer) — number — 외래 키 → Company.Key — NOT NULL
tb_attach
- Key (a_id) — number — 기본 키 — NOT NULL
- Field2 (a_uploadPath) — varchar(200)
- Field3 (a_filename) — varchar(200)
- Field4 (a_filetype) — char(1)
- Key (a_board) — number — 외래 키 → teamBoard.Key — NOT NULL
teamBoard
- Key (teamboard_keyid) — number — 기본 키 — NOT NULL
- Field (tb_title) — varchar
- Field (tb_content) — text
- Field (tb_date) — date
- Field (tb_writer) — varchar(100)
- Key (tb_team) — number — 외래 키 → Team.Key — NOT NULL