utc
Tables (9)
Attendence
- attendence_id — int — Primary key — NOT NULL
- member_id — int — NOT NULL
- check_in — timestamp
- check_out — timestamp
Board
- board_id — int — Primary key — NOT NULL
- title — varchar
- content — varchar
- created_at — timestamp
- created_by — int — NOT NULL
- modified_at — timestamp
- modified_by — int — NOT NULL
Classroom
- classroom_id — int — Primary key — NOT NULL
- grade — int
- class — int
Follow
- follow_id — int — Primary key — NOT NULL
- from_member_id — int — NOT NULL
- to_member_id — int — NOT NULL
- flag — boolean
Lecture
- lecture_id — int — Primary key — NOT NULL
- title — varchar
- mentor_id — int — NOT NULL
- flag — int
- Field — VARCHAR(255)
Like
- like_id — int — Primary key — NOT NULL
- member_id — int — NOT NULL
- board_id — int — NOT NULL
- flag — boolean
Member
- member_id — int — Primary key — NOT NULL
- nickname — varchar
- password — varchar
- name — varchar
- birthday — date
- email — varchar
- role — int
- point — int
- role_id — int — NOT NULL
- classroom_id — int — NOT NULL
Registration
- reg_id — int — Primary key — NOT NULL
- member_id — int — NOT NULL
- Field3 — VARCHAR(255)
Role
- role_id — int — Primary key — NOT NULL
- role_name — varchar