devopskindergarten

Tables (5)

Untitled (user_authority)

  • id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
  • Key (authority_id) — NOT NULL — Foreign key → Untitled2.Key — NOT NULL

Untitled (comment)

  • Key (comment_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
  • Key (parent_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — NOT NULL
  • Field (like_count)

Untitled (lecture)

  • Key (lecture_id) — NOT NULL — Primary key — NOT NULL
  • Field (title) — NOT NULL
  • Field (content) — NOT NULL
  • Field (created_date) — NOT NULL
  • Field (updated_date) — NOT NULL

Untitled2 (authority)

  • Key (authority_id) — NOT NULL — Primary key — NOT NULL
  • Field (authority_name) — NOT NULL

User (user)

  • id (user_id) — NOT NULL — Primary key — NOT NULL
  • Field (username) — NOT NULL
  • Field (password) — NOT NULL
  • Field (name) — NOT NULL
  • Field (email) — NOT NULL