modify
Tables (8)
Address (address)
- Zipcode (zipcode) — VARCHAR(50)
- Street (street) — VARCHAR(50)
- City (city) — VARCHAR(50)
Auth (auth)
- EmployeeAuthNo (employeeAuthNo) — BIG_INT — Primary key — NOT NULL
- Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
- Auth (auth) — VARCHAR(30)
- RegDate (regDate) — Date
- UpDate (upDate) — Date
Board (board)
- Board_no (board_no) — BIG_INT — Primary key — NOT NULL
- EmployeeAuthNo (employeeAuthNo) — BIG_INT — Foreign key → Auth.EmployeeAuthNo — NOT NULL
- Title (title) — VARCHAR(100)
- Writer (writer) — VARCHAR(50)
- Content (content) — VARCHAR(1000)
- RegDate (regDate) — Date
- UpDate (upDate) — Date
Calendar (calendar)
- Calendar_no (calendar_no) — BIG_INT — Primary key — NOT NULL
- Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
- Name (name) — VARCHAR(10)
- Details (details) — VARCHAR(10)
- Email (email) — VARCHAR(100)
- Start (start) — Date
- End (end) — Date
Employee (employee)
- Employee_no (employee_no) — BIG_INT — Primary key — NOT NULL
- Team_no (team_no) — BIG_INT — Foreign key → Team.Team_no — NOT NULL
- Email (email) — VARCHAR(100)
- Name (name) — VARCHAR(50)
- Password (password) — VARCHAR(200)
- PhoneNumber (phoneNumber) — VARCHAR(20)
- Team (team) — VARCHAR(20)
- RegDate (regDate) — Date
- UpDate (upDate) — Date
Project (project)
- Project_no (project_no) — BIG_INT — Primary key — NOT NULL
- Team_no (team_no) — BIG_INT — Foreign key → Team.Team_no — NOT NULL
- Title (title) — VARCHAR(20)
- Team (team) — VARCHAR(10)
- Person (person) — VARCHAR(20)
- Due (due) — Date
- Status (status) — VARCHAR(10)
Schedule (schedule)
- Schedule_no (schedule_no) — BIG_INT — Primary key — NOT NULL
- Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
- Name (name) — VARCHAR(20)
- Email (emailE) — VARCHAR(50)
- Team (team) — VARCHAR(50)
- Time8 (time8) — VARCHAR(20)
- Time9 (time9) — VARCHAR(20)
- Time10 (time10) — VARCHAR(20)
- Time11 (time11) — VARCHAR(20)
- Time12 (time12) — VARCHAR(20)
- Time13 (time13) — VARCHAR(20)
- Time14 (time14) — VARCHAR(20)
- Time15 (time15) — VARCHAR(20)
- Time16 (time16) — VARCHAR(20)
- Time17 (time17) — VARCHAR(20)
- Time18 (time18) — VARCHAR(20)
- Time19 (time19) — VARCHAR(20)
- Time20 (time20) — VARCHAR(20)
Team (team)
- Team_no (team_no) — BIG_INT — Primary key — NOT NULL
- Team (team) — VARCHAR(20)