KTB-Community

Tables (4)

comment (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL
  • content (Field2) — TEXT — NOT NULL
  • deleted (Field3) — TINYINT(1) — NOT NULL
  • created_at (Field) — TIMESTAMP — NOT NULL

like (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.id — NOT NULL

post (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100) — NOT NULL
  • content (Field2) — LONGTEXT — NOT NULL
  • attachement_image_url (Field3) — TEXT
  • deleted (Field5) — TINYINT(1) — NOT NULL
  • lookup_count (Field6) — INT — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL

user

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (VARCHAR(255)) — VARCHAR(255) — NOT NULL
  • password (Field2) — VARCHAR(255) — NOT NULL
  • nickname (Field) — VARCHAR(100) — NOT NULL
  • profile_image_url (Field3) — TEXT — NOT NULL
  • deleted (Field4) — TINYINT(1) — NOT NULL