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