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