sparta-posting

Tables (3)

Untitled (Board)

  • id — int — Primary key — NOT NULL — auto increment
  • boardContent — varchar — NOT NULL — board's content
  • category — varchar — NOT NULL — board's category(QUESTION, DIARY)
  • user_id (users_id) — int — Foreign key → users.id — NOT NULL — FK from Users table

Untitled (Comment)

  • id — int — Primary key — NOT NULL
  • commentContent — varchar — NOT NULL — comment's content
  • board_id — int — Foreign key → Untitled.id — NOT NULL — FK from Board table
  • id (users_id) — int — Foreign key → users.id — NOT NULL — FK from Users table

users

  • id — int — Primary key — NOT NULL — auto increment
  • username — varchar — NOT NULL — user's username
  • email — varchar — NOT NULL — user's email address
  • password — varchar — NOT NULL — user's password
  • role — varchar — NOT NULL — user's authorization(ADMIN, USER)