F-Project

Tables (8)

JoinStudy (Untitled)

  • Username (username) — String — Foreign key → User.Username — NOT NULL
  • StudyId (study_id) — Int — Foreign key → Study.StudyId — NOT NULL

Participated (participated)

  • StudyId (study_id) — Int — Foreign key → Study.StudyId — NOT NULL
  • Username (username) — String — Foreign key → User.Username — NOT NULL

Study (study)

  • StudyId (study_id) — Int — Primary key — NOT NULL
  • Owner (owner) — String — Foreign key → User.Username — NOT NULL
  • Category (category) — VARCHAR(10)
  • Title (title) — VARCHAR(500)
  • Desc (desc) — TextField
  • MaxPeople (max_people) — Int
  • StartAt (start_at) — Stirng
  • EndAt (end_at) — Stirng
  • MemberNumber (member_number) — Int

StudyTodos (study_todos)

  • StudyTodosId (study_todos_id) — Int — Primary key — NOT NULL
  • StudyId (study_id) — Int — Foreign key → Study.StudyId — NOT NULL
  • ManagementPK (management_pk) — Int — Foreign key → StudyTodosManagement.ManagementPK — NOT NULL
  • Username (username) — String — Foreign key → User.Username — NOT NULL
  • Title (title) — VARCHAR(500)
  • Content (content) — TextField
  • StartAt (start_at) — Stirng
  • EndAt (end_at) — Stirng
  • IsCompleted (is_completed) — tinyint(1)

StudyTodosManagement (study_todos_management)

  • ManagementPK (management_pk) — Int — Primary key — NOT NULL

Tag (tag)

  • TagId (tag_id) — Int — Primary key — NOT NULL
  • TodosId (todos_id) — Int — Foreign key → Todos.TodosId — NOT NULL
  • Content (content) — VARCHAR(30)

Todos (todos)

  • TodosId (todos_id) — Int — Primary key — NOT NULL
  • Username (username) — String — Foreign key → User.Username — NOT NULL
  • Title (title) — VARCHAR(500)
  • Content (content) — TextField
  • When (when) — timestamp
  • StartedAt (started_at) — VARCHAR(5)
  • ExpiredAt (expired_at) — VARCHAR(5)
  • Field — tinyint(1)

User (user)

  • Username (username) — String — Primary key — NOT NULL
  • FirstName (first_name) — VARCHAR(14)
  • LastName (last_name) — VARCHAR(14)
  • Nickname (nickname) — VARCHAR(14)
  • Image (image) — JPEG