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