news

Tables (3)

COMMENT

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • NEWS (PK) — NEWS — Foreign key → NEWS.ID — NOT NULL
  • WRITER (PK2) — USER — Foreign key → NEWS.WRITER — NOT NULL
  • LIKE (Field3) — BIGINT
  • CONTENT (Field4) — VARCHAR(50)
  • Field

NEWS

  • ID (PK) — BIGINT — Primary key — NOT NULL
  • WRITER (PK2) — USER — Foreign key → USER.ID — NOT NULL
  • TITLE (Field) — VARCHAR(20)
  • CONTENT (Field2) — LONGTEXT
  • Field4

USER

  • ID (PK) — BIGINT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(10)
  • EMAIL (Field2) — VARCHAR(20)
  • PASSWORD (Field3) — VARCHAR(20)
  • IMAGE (Field4)
  • Field5