innovationcamp_hw4

Tables (7)

content_like

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → contents.id — NOT NULL
  • id (Key22) — Long — Foreign key → contents.id — NOT NULL

contents

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → user.id — NOT NULL
  • title (Field1) — String
  • name (Field2) — String
  • contents (Field3) — String
  • content_like_count (Field4) — Long
  • reply_like_count (Field5) — Long
  • re_reply_like_count (Field6) — Long
  • created_at (Field7) — String
  • modified_at (Field8) — String

re_reply

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → reply.id — NOT NULL
  • id (Key22) — Long — Foreign key → reply.id — NOT NULL
  • id (Key222) — Long — Foreign key → reply.id — NOT NULL
  • username (Field1) — String
  • re_reply (Field2) — String
  • re_reply_like_count (Field3) — Long
  • created_at (Field4) — String
  • modified_at (Field5) — String

re_reply_like

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → re_reply.id — NOT NULL
  • id (Key22) — Long — Foreign key → re_reply.id — NOT NULL
  • id (Key222) — Long — Foreign key → re_reply.id — NOT NULL
  • id (Key2222) — Long — Foreign key → re_reply.id — NOT NULL

reply

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → contents.id — NOT NULL
  • id (Key22) — Long — Foreign key → contents.id — NOT NULL
  • username (Field1) — String
  • reply (Field2) — String
  • count_re_reply (Field3) — String
  • re_reply_like_count (Field4) — Long
  • created_at (Field5) — String
  • modified_at (Field6) — String

reply_like

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → reply.id — NOT NULL
  • id (Key22) — Long — Foreign key → reply.id — NOT NULL
  • id (Key222) — Long — Foreign key → reply.id — NOT NULL

user

  • id (Key) — Long — Primary key — NOT NULL
  • uername (Field1) — String
  • password (Field2) — String
  • created_at (Field3) — String
  • modified_at (Field4) — String