cafe_persona_domain

Tables (12)

Bookmarks (bookmarks)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → Users.id — NOT NULL
  • cafe_id (FK2) — bigint — Foreign key → Cafes.id — NOT NULL
  • collection_name (Field) — varchar

CafeTags (cafe_tags)

  • id (Key) — bigint — Primary key — NOT NULL
  • cafe_id (FK) — bigint — Foreign key → Cafes.id — NOT NULL
  • category_id (FK2) — bigint — Foreign key → Categories.id — NOT NULL

Cafes (cafes)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • type (Field2) — varchar

Categories (categories)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • type (Field2) — varchar

Events (events)

  • id (Key) — bigint — Primary key — NOT NULL
  • cafe_id (FK) — bigint — Foreign key → Cafes.id — NOT NULL
  • title (Field2) — varchar
  • start_date (Field3) — date
  • end_date (Field4) — date
  • description (Field5) — varchar

Followers (followers)

  • followers_id (FK) — bigint
  • following_id (FK2) — bigint

Menus (menus)

  • id (Key) — bigint — Primary key — NOT NULL
  • cafe_id (FK) — bigint — Foreign key → Cafes.id — NOT NULL
  • name (Field) — varchar
  • price (Field2) — decimal
  • description (Field3) — varchar

Notifications (notifications)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → Users.id — NOT NULL
  • message (Field) — barchar
  • create_at (Field2) — datetime
  • is_read (Field3) — boolean

Photos (photos)

  • id (Key) — bigint — Primary key — NOT NULL
  • review_id (FK) — bigint — Foreign key → Reviews.id — NOT NULL
  • cafe_id (FK2) — bigint — Foreign key → Cafes.id — NOT NULL
  • url (Field) — varchar
  • type (Field2) — varchar

Resevations (reservations)

  • id (Key) — bigint — Primary key — NOT NULL
  • cafe_id (FK) — bigint — Foreign key → Cafes.id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → Users.id — NOT NULL
  • date (Field3) — timestamp
  • status (Field4) — varchar

Reviews (reviews)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → Users.id — NOT NULL
  • cafe_id (FK2) — bigint
  • rating (Field3) — int
  • content (Field4) — varchar
  • create_at (Field5) — datetime

Users (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar
  • password_hash (Field3) — varchar
  • preference (Field4) — varchar
  • role (Field5) — varchar