맛케터 리뷰관련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)