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