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)