week assignment

Tables (3)

Comments

  • id — BIGINT — Primary key — NOT NULL
  • postId — BIGINT — Foreign key → Posts.id — NOT NULL
  • memberId — BIGINT — Foreign key → Posts.memberId — NOT NULL
  • content — VARCHAR(100)

Members

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(10)

Posts

  • id — BIGINT — Primary key — NOT NULL
  • memberId — BIGINT — Foreign key → Members.id — NOT NULL
  • content — VARCHAR(200)