Kkodac

Tables (7)

Comment (CopyOfCopyOfUntitled)

  • id (Key2) — int — Primary key — NOT NULL
  • post_id (Key22) — int — Foreign key → Post.id — NOT NULL
  • user_id (Key222) — int — Foreign key → Post.user_id — NOT NULL
  • description (Field3) — varchar
  • created_at (Field6) — date
  • updated_at (Field7) — date

File (CopyOfCopyOfUntitled2)

  • id (Key2) — int — Primary key — NOT NULL
  • url (Field) — varchar
  • original_name (Field2) — varchar
  • created_at (Field6) — date

Filemapper (mapper)

  • id (Key2) — int — Primary key — NOT NULL
  • post_id (Key22) — int — Foreign key → Post.id — NOT NULL
  • file_id (Key23) — int — Foreign key → File.id — NOT NULL
  • post_id (Field2) — varchar
  • created_at (Field6) — date

Follow (Subscribe)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key22) — int — Foreign key → User.id — NOT NULL
  • follower_id (Key222) — int — Foreign key → User.file_id — NOT NULL
  • created_at (Field6) — date

Like (CopyOfCopyOfCopyOfUntitled)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key22) — int — Foreign key → User.id — NOT NULL
  • post_id (Key222) — int — Foreign key → Post.user_id — NOT NULL
  • created_at (Field6) — date

Post (CopyOfUntitled)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key22) — int — Foreign key → User.id — NOT NULL
  • file_id (Key23) — int — Foreign key → File.id — NOT NULL
  • title (Field2) — varchar
  • description (Field3) — varchar
  • category (Field5) — varchar
  • created_at (Field6) — date
  • updated_at (Field7) — date

User (Untitled)

  • id (Key2) — int — Primary key — NOT NULL
  • file_id (Key22) — int — Foreign key → File.id — NOT NULL
  • user_id (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • introduction (Field5) — varchar
  • created_at (Field6) — date
  • updated_at (Field7) — date