서구실

테이블 (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