test

Tables (4)

Author

  • author_id — int — Primary key — NOT NULL — abc
  • name — varchar
  • profile — varchar
  • created — datetime

Comment

  • id — int — Primary key — NOT NULL — abc
  • author_id (author_id2) — int — Foreign key → Author.author_id — NOT NULL — abc
  • description — varchar
  • created — datetime
  • topic_id (topic_id2) — int — Foreign key → Topic.topic_id — NOT NULL — abc

Dormant

  • author_id — int — Primary key — NOT NULL
  • created — datetime

Topic

  • topic_id — int — Primary key — NOT NULL — abc
  • title — varchar
  • description — varchar
  • created — datetime
  • tag — varchar