CamCODEr
Tables (4)
MESSAGES (messages)
- Key (message_code) — auto increment — Primary key — NOT NULL
- Field (send_date) — create at
- Field (content) — varchar(3000)
- Field (from) — FK(user_code)
- Field (to) — FK(user_code)
- Field (isRead) — T/F
- Field
TEACHERS (teachers)
- Key — auto increament — Primary key — NOT NULL
- Field (user_code) — FK(user)
- Field (description) — LONGTEXT
- Field (expertise) — LONGTEXT
- Field (price) — int(10)
- Field (profile) — VARCHAR(256)
- Field2
Untitled (USERS)
- Key (user_code) — auto increment — Primary key — NOT NULL
- user_id
- user_pw
- user_name (join_day) — create at
- Field4 (user_name)
Untitled (Request)
- Key (request_code) — auto_increment — Primary key — NOT NULL
- Field (teacher_code) — FK(user_code)
- Field (student_code) — FK(user_code)
- Field (request_date) — create at
- Field (room_num)
- Field (teaching_date)
- Field (teaching _time)
- Field (status)