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