LikeLionLMS
Tables (7)
Answer
- PK (answer_id) — int — Primary key — NOT NULL
- FK (question_id) — int — Foreign key → Question.PK — NOT NULL
- FK (user_ID) — int — Foreign key → User.PK — NOT NULL
- Field (title) — varchar(100)
- Field (name) — varchar(20)
- Field (content) — varchar(1000)
- Field (created_at) — timestamp()
- Field (last_edited_at) — timestamp()
- Field (views) — tinyint
- Field (private) — boolean
Assginment (Assignment)
- PK (assign_title) — varchar(50) — Primary key — NOT NULL
- FK (code) — varchar(50) — Foreign key → Course.PK — NOT NULL
- FK (user_ID) — int — Foreign key → Course.FK — NOT NULL
- Field (created_at) — timestamp()
- Field (end_date) — timestamp()
- Field (name) — varchar(50)
- Field (content) — varchar(1000)
- Field (sub_status) — boolean
- Field (score_status) — boolean
- Field (score_date) — timestamp()
- Field (feedback) — varchar(500)
Assignment_submit (Assignment_Submit)
- PK (name) — varchar(100) — Primary key — NOT NULL
- FK (assign_title) — varchar(50) — Foreign key → Assginment.PK — NOT NULL
- FK (user_ID) — int — Foreign key → Assginment.FK — NOT NULL
- Field (content) — varchar(1000)
- Field (submit_date) — timestamp()
- Field (last_submit) — timestamp()
- Field2 (file_name) — varchar(100)
- Field (file_type) — varchar(20)
Course
- PK (code) — varchar(50) — Primary key — NOT NULL
- FK (user_ID) — int — Foreign key → User.PK — NOT NULL
- Field (name) — varchar(255)
- Field (propessor) — varchar(20)
- Field (date) — timestamp()
- Field (num_stu) — tinyint
- Field (attendance) — int
Lecture (Lectures)
- PK (week) — int — Primary key — NOT NULL
- FK (course_code) — varchar(20) — Foreign key → Course.PK — NOT NULL
- Field (title) — varcahr(50)
- Field (created_at) — timestamp()
- Field (date) — timestamp()
- Field (progress) — int
- Field (attendance) — boolean
Question
- PK (question_id) — int — Primary key — NOT NULL
- FK (user_ID) — int — Foreign key → User.PK — NOT NULL
- FK (code) — varchar(50) — Foreign key → Course.PK — NOT NULL
- Field (title) — varchar(100)
- Field3 (name) — varchar(20)
- Field (content) — varchar(1000)
- Field (created_at) — timestamp()
- Field2 (last_edited_at) — timestamp()
- Field (views) — tinyint
- Field (private) — boolean
User
- PK (ID) — int — Primary key — NOT NULL
- Field (univ_num) — int
- Field2 (name) — varchar(255)
- Field2 (grade) — int
- Field3 (major) — varchar(255)
- Field (loginID) — varchar(30)
- Field (password) — varchar(30)
- Field (authority) — varchar(255)
- Field3 (email) — varchar(50)