서구실
테이블 (14)
Article
- article_id — INTEGER — 기본 키 — NOT NULL
- title — VARCHAR(100)
- question — bool
- content — text
- created_at — Datetime
- updated_at — Datetime
- img — VARCHAR(255)
- community_type — VARCHAR(20)
- user_id — VARCHAR(30) — 외래 키 → Users.user_id — NOT NULL
ArticleTag
- tag_id — VARCHAR(30) — 외래 키 → Tag.tag_id — NOT NULL
- article_id — INTEGER — 외래 키 → Article.article_id — NOT NULL
Article_reaction
- article_id — INTEGER — 외래 키 → Article.article_id — NOT NULL
- reaction_id — INTEGER
- reaction — VARCHAR(30)
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
Comment
- comment_id — INTEGER — 기본 키 — NOT NULL
- content — text
- created_at — Datetime
- updated_at — Datetime
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
- article_id — INTEGER — 외래 키 → Article.article_id — NOT NULL
- parent_id — INTEGER — comment_id 참조
Comment_reaction
- comment_id (comment_id2) — INTEGER — 외래 키 → Comment.comment_id — NOT NULL
- reaction_id — INTEGER
- reaction — VARCHAR(30)
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
Dogs
- dog_id — INTEGER — 기본 키 — NOT NULL
- dog_name — VARCHAR(20)
- dog_gender — VARCHAR(20)
- dog_desexed — bool
- isRepresentative — bool
- dog_type — VARCHAR(20)
- dog_weight — float
- dog_age — INTEGER
- dog_char — VARCHAR(100)
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
Favorite
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
- place_id — INTEGER — 외래 키 → Place.place_id — NOT NULL
- created_at — Datetime
Place
- place_id — INTEGER — 기본 키 — NOT NULL
- name — VARCHAR(100)
- address — VARCHAR(200)
- community_type — VARCHAR(20)
- condition — VARCHAR(50)
- lat — float
- ing — float
- average_score — float
Review
- review_id — INTEGER — 기본 키 — NOT NULL
- short_review — VARCHAR(100)
- full_review — text
- img — VARCHAR(255)
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
- place_id — INTEGER — 외래 키 → Place.place_id — NOT NULL
Scrap
- scrap_id — INTEGER — 기본 키 — NOT NULL
- created_at — Datetime
- user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
- article_id — INTEGER — 외래 키 → Article.article_id — NOT NULL
Tag
- tag_id — VARCHAR(30) — 기본 키 — NOT NULL
- name — VARCHAR(50)
- usage_count — INTEGER
Users
- user_id — INTEGER — 기본 키 — NOT NULL
- email — VARCHAR(50)
- passwd — VARCHAR(100)
- nickName — VARCHAR(20)
- village — VARCHAR(30)
place_suggestion
- suggestion_id (report_id) — INTEGER — 기본 키 — NOT NULL
- suggestion — ENUM
- reason — TEXT
- created_at — DATETIME
- user_id (user_id2) — INTEGER — 외래 키 → Users.user_id — NOT NULL
- place_id (place_id2) — INTEGER — 외래 키 → Place.place_id — NOT NULL
report
- report_id — INTEGER — 기본 키 — NOT NULL
- target_type — ENUM
- target_id — INTEGER
- reason — VARCHAR(255)
- created_at — DATETIME
- reporter_user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL
- reported_user_id — INTEGER — 외래 키 → Users.user_id — NOT NULL