OurTinyClass
Tables (12)
article
- Key (id) — int — Primary key — NOT NULL
- Key (menber_id) — int — Foreign key → member.Key — NOT NULL
- Key (classrom_id) — int — Foreign key → classroom.Key — NOT NULL
- Field (title) — int
- Field (content) — int
- Field (article_type) — int
- Field (hit) — int
- Field (created_at) — timestamp
- Field (created_by) — int
- Field (modified_at) — timestamp
- Field (modified_by) — int
- Field (deleted_at) — timestamp
article_comment
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Key (article_id) — int — Foreign key → article.Key — NOT NULL
- Field (content) — varchar
- Field (created_at) — timestamp
- Field (modified_at) — timestamp
- Field (deleted_at) — timestamp
attendence
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Field (check_in) — timestamp
- Field (check_out) — timestamp
- Field (status) — int
classroom
- Key (id) — int — Primary key — NOT NULL
- Field (year) — int
- Field (grade) — int
- Field (class) — int
collection
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Field (background_image) — list
- Field (head_list) — list
- Field (top_list) — list
- Field (under_list) — list
- Field (shoes_list) — list
item
- Key (id) — int — Primary key — NOT NULL
- Field (image_url) — varchar
- Field (price) — int
- Field (part_number) — int
lecture
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Field (title) — varchar
- Field (day_of_week) — int
- Field (time_table) — int
- Field (lecture_type) — int
- Field (lecture_url) — varchar
like
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Key (board_id) — int — Foreign key → article.Key — NOT NULL
- Key (flag) — boolean
member
- Key (id) — int — Primary key — NOT NULL
- Key (role_id) — int — Foreign key → role.Key — NOT NULL
- Key (classroom_id) — int — Foreign key → classroom.Key — NOT NULL
- Field (member_id) — varchar
- Field (password) — int
- Field (name) — int
- Field (birthday) — date
- Field (email) — varchar
- Field (point) — int
- Field (deleted_at) — timestamp
proflie (profile)
- Key (id) — int — Primary key — NOT NULL
- Field (profile_image) — varchar
- Field (background_image) — int
- Field (position_head) — int
- Field (position_top) — int
- Field (position_under) — int
- Field (position_shoes) — int
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
role
- Key (id) — int — Primary key — NOT NULL
- Field (role_name) — varchar
schedule
- Key (id) — int — Primary key — NOT NULL
- Key (member_id) — int — Foreign key → member.Key — NOT NULL
- Key (lecture_id) — int — Foreign key → lecture.Key — NOT NULL
- Field (schedule_date) — date