test

Tables (10)

gift (Untitled3)

  • id (Key) — String — Primary key — NOT NULL
  • packageId (Key2) — string — Foreign key → package.id — NOT NULL

issuedTickets (Untitled5)

  • id (Key) — string — Primary key — NOT NULL
  • receivedGiftId (Key2) — int — Foreign key → receivedGift.id — NOT NULL
  • giftId (Key22) — string — Foreign key → receivedGift.giftId — NOT NULL
  • packageId (Key222) — string — Foreign key → receivedGift.packageId — NOT NULL
  • orderTicketId (Key3) — int — Foreign key → orderTicket.id — NOT NULL
  • id (Key23) — int — Foreign key → orderTicket.id — NOT NULL
  • resevationId (Key4) — string — Foreign key → reservation.id — NOT NULL
  • id (Key24) — int — Foreign key → reservation.scheduleId — NOT NULL
  • ticketId (Key223) — int — Foreign key → reservation.ticketId — NOT NULL

orderTicket (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → ticket.id — NOT NULL

package (Untitled)

  • id (Key) — string — Primary key — NOT NULL
  • title (Field) — string
  • content (Field2) — string

packageProduct (Untitled2)

  • id (Key) — string — Primary key — NOT NULL
  • packageId (Key2) — string — Foreign key → package.id — NOT NULL
  • title (Field) — string
  • content (s) — string

packageProductSelect (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • packageId (Key22) — string — Foreign key → packageProduct.packageId — NOT NULL
  • packageProductId (Key2) — string — Foreign key → packageProduct.id — NOT NULL
  • giftId (Key3) — String — Foreign key → gift.id — NOT NULL
  • giftPackageId (Key23) — string — Foreign key → gift.packageId — NOT NULL

receivedGift (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • giftId (Key2) — string — Foreign key → gift.id — NOT NULL
  • packageId (Key22) — string — Foreign key → gift.packageId — NOT NULL

reservation (Untitled10)

  • id (Key) — string — Primary key — NOT NULL
  • scheduleId (Key2) — int — Foreign key → schedule.id — NOT NULL
  • ticketId (Key22) — int — Foreign key → schedule.ticketId — NOT NULL

schedule (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • ticketId (Key2) — int — Foreign key → ticket.id — NOT NULL

ticket (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — string