test
Tables (5)
Bucket (Untitled3)
- id — int — Primary key — NOT NULL
- customerId — int
- payment — boolean
- price — double
- hotelId — Long — Foreign key → Hotel.id
Category (Untitled4)
- id — Long — Primary key — NOT NULL
- name — String
- title — String
- content — String
Hotel (Untitled5)
- id — Long — Primary key
- name — String
- address — String
- startDate — Date
- endEntry — Date
- booked — boolean
- price — double
- content — string
Reply (Untitled2)
- id — Long — Primary key — NOT NULL
- title — string
- content — string
- entrydate — DATE
- modifyDate — DATE
- score — int
- customerId — int
- hotelId — Long — Foreign key → Hotel.id
- userId — Long — Foreign key → User.id — NOT NULL
User (Untitled)
- id — Long — Primary key — NOT NULL
- username — String
- password — String