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