couple record
Tables (8)
Untitled4 (BaseEntity)
- created_at — DATETIME
- updated_at — DATETIME
cafe
- post_id — Long — Foreign key → post.post_id — NOT NULL
- price_rating — DECIMAL(1,1)
- flavor_rating — DECIMAL(1,1)
- atmosphere_rating — DECIMAL(1,1)
- service_rating — DECIMAL(1,1)
entertainment
- post_id — Long — Foreign key → post.post_id — NOT NULL
- price_rating — DECIMAL(1,1)
- facility_rating — DECIMAL(1,1)
- fun_rating — DECIMAL(1,1)
- service_rating — DECIMAL(1,1)
photo
- photo_id — Long — Primary key — NOT NULL
- photo_url — TEXT
- post_id — Long — Foreign key → post.post_id — NOT NULL
post
- post_id — Long — Primary key — NOT NULL
- name — VARCHAR
- address — VARCHAR
- total_rating — DECIMAL(1,1)
- man_review — TEXT
- woman_review — TEXT
- visit_date — DATE
- category — VARCHAR
restaurant
- post_id — Long — Foreign key → post.post_id — NOT NULL
- price_rating — DECIMAL(1,1)
- flavor_rating — DECIMAL(1,1)
- atmosphere_rating — DECIMAL(1,1)
- service_rating — DECIMAL(1,1)
stay
- post_id — Long — Foreign key → post.post_id — NOT NULL
- price_rating — DECIMAL(1,1)
- facility_rating — DECIMAL(1,1)
- atmosphere_rating — DECIMAL(1,1)
- service_rating — DECIMAL(1,1)
tag
- tag_id — Long — Primary key — NOT NULL
- content — VARCHAR
- post_id — Long — Foreign key → post.post_id — NOT NULL