맛케터 리뷰관련db

테이블 (5)

hashtags

  • id — SERIAL
  • contents — VARCHAR(32) — NOT NULL
  • reviews_id — INT — 외래 키 → reviews_hashtags.reviews_id — NOT NULL
  • hashtags_id — INT — 외래 키 → reviews_hashtags.hashtags_id — NOT NULL

restaurants

  • id (Key) — SERIAL — 기본 키 — NOT NULL
  • restaurants_name — CHAR(100) — NOT NULL
  • address — CHAR(100) — NOT NULL
  • phone — CHAR(100) — NOT NULL
  • opening_hours — CHAR(100) — NOT NULL
  • rating — FLOAT — NOT NULL
  • food_type — CHAR(20) — NOT NULL
  • image — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • category — VARCHAR(100)
  • food_menu — JSONB

reviews

  • id (Key) — SERIAL — 기본 키 — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • contents — TEXT — NOT NULL
  • date — DATE — NOT NULL
  • rating — NUMERIC — NOT NULL
  • author_id (Key3) — INT — 외래 키 → users.id — NOT NULL
  • restaurant_id (Key2) — INT — 외래 키 → restaurants.id — NOT NULL
  • reviews_id — INT — 외래 키 → reviews_hashtags.reviews_id — NOT NULL

reviews_hashtags

  • reviews_id — INT — 기본 키 — NOT NULL
  • hashtags_id — INT — 기본 키 — NOT NULL

users

  • id (Key) — SERIAL — 기본 키 — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • user_password — VARCHAR(255) — NOT NULL
  • password (Field)