community

Tables (3)

Board (Untitled2)

  • Id (key) — BIGINT AHTO_INCREMENT PK — Primary key — NOT NULL
  • title (board title) — VARCHAR(200) NOT NULL
  • content (board content) — TEXT NOT NULL
  • views (board views) — INT DEFAULT 0
  • created_At (board created date) — DATE TIME DEFAULT CURRNET_TIMESTAMP
  • updated_At (board updated date) — DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  • userId (user Id) — BIGINT NOT NULL FK — Foreign key → User.Id — NOT NULL

Comment (Untitled3)

  • Id (key) — BIGINT AUTO_INCREMENT PK — Primary key — NOT NULL
  • content (comment content) — TEXT NOT NULL
  • created_At (comment create date) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • userId (user Id) — BIGINT NOT NULL FK — Foreign key → User.Id — NOT NULL
  • boardId (board Id) — BIGINT NOT NULL FK — Foreign key → Board.Id — NOT NULL
  • parentId (parent Id) — BIGINT NOT NULL FK — Foreign key → Comment.Id — NOT NULL

User (Untitled)

  • Id (key) — BIGINT AUTO_INCREMENT PK — Primary key — NOT NULL
  • userId (user Id) — VARCHAR(50) NOT NULL UNIQUE
  • password (user password) — VARCHAR(255) NOT NULL
  • nickname (user nickname) — VARCHAR(30) NOT NULL UNIQUE
  • role — ENUM ('USER' , 'ADMIN') NOT NULL DEFAULT 'USER'
  • created_At (user created date) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • updated_At (user updated date) — DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  • deleted_At (user deleted date) — DATETIME NULL DEFAULT NULL