agaein

Tables (9)

article (Article)

  • id — Integer — Primary key — NOT NULL
  • user_id (id2) — Integer — Foreign key → user.id — NOT NULL
  • title (Field2) — varchar(255)
  • content (Field3) — Text
  • created_at (Field6) — Date
  • updated_at (Field7) — Date

breed (CopyOfCopyOfCopyOfCopyOfArticle22)

  • id — Integer — Primary key — NOT NULL
  • breed (Field2) — varchar(255)

comment (CopyOfCopyOfArticle)

  • id — Integer — Primary key — NOT NULL
  • article_id (id2) — Integer — Foreign key → article.id — NOT NULL
  • user_id (id3) — Integer — Foreign key → user.id — NOT NULL
  • content (Field3) — Text
  • created_at (Field6) — Date
  • updated_at (Field7) — Date

image (CopyOfCopyOfCopyOfCopyOfArticle2)

  • id — Integer — Primary key — NOT NULL
  • article_id (id2) — Integer — Foreign key → article.id — NOT NULL
  • url (Field3) — varchar(255)

lfg (CopyOfCopyOfCopyOfArticle2)

  • id — Integer — Primary key — NOT NULL
  • article_id (id2) — Integer — Foreign key → article.id — NOT NULL
  • breed_id (id3) — Integer — Foreign key → breed.id — NOT NULL
  • name (Field6) — varchar(255)
  • feature (Field3) — varchar(255)
  • gender (Field4) — varchar(255)
  • location (Field5) — json
  • found_date (Field) — Date

lfp (CopyOfCopyOfCopyOfCopyOfArticle23)

  • id — Integer — Primary key — NOT NULL
  • article_id (id2) — Integer — Foreign key → article.id — NOT NULL
  • breed_id (id3) — Integer — Foreign key → breed.id — NOT NULL
  • name (Field6) — varchar(255)
  • feature (Field3) — varchar(255)
  • gender (Field4) — varchar(255)
  • gratuity (Field7) — Integer
  • location (Field5) — json
  • lost_date (Field) — Date

nested_comment (CopyOfCopyOfCopyOfArticle)

  • id — Integer — Primary key — NOT NULL
  • user_id (id3) — Integer — Foreign key → user.id — NOT NULL
  • comment_id (id2) — Integer — Foreign key → comment.id — NOT NULL
  • content (Field3) — Text
  • created_at (Field6) — Date
  • updated_at (Field7) — Date

review (CopyOfArticle)

  • id — Integer — Primary key — NOT NULL
  • article_id (id2) — Integer — Foreign key → article.id — NOT NULL

user (CopyOfArticle2)

  • id — Integer — Primary key — NOT NULL
  • kakao_id (Field2) — varchar(255)
  • password (Field3) — Text
  • Field
  • Field4
  • Field5
  • created_at (Field6) — Date
  • updated_at (Field7) — Date