ojt

Tables (3)

Comment (comment)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Ip Address (ip_address) — VARCHAR(255)
  • Content (content) — VARCHAR(2000)
  • CreatedAt (created_at) — TIMESTAMP
  • UpdatedAt (updated_at) — TIMESTAMP
  • Post Id (post_id) — BIGINT — Foreign key → Post.ID — NOT NULL

Post (post)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Ip Address (ip_address) — VARCHAR(255)
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR(2000)
  • CreatedAt (created_at) — TIMESTAMP
  • UpdatedAt (updated_at) — TIMESTAMP

Remmendation (recommendation)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Ip Address (ip_address) — VARCHAR(255)
  • CreatedAt (created_at) — TIMESTAMP
  • UpdatedAt (updated_at) — TIMESTAMP
  • Post Id (post_id) — BIGINT — Foreign key → Post.ID — NOT NULL