Reborn

Tables (16)

Bundle (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • bundleType (Field) — BundleType
  • name (Field2) — String
  • price (Field3) — int
  • Company.id (Key2) — Long — Foreign key → Company.id — NOT NULL

ChatContent (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • content (Field) — String
  • senderType (Field2) — SenderType
  • createDt (Field3) — LocalDateTime
  • ChatRoom.id (Key2) — Long — Foreign key → ChatRoom.id — NOT NULL

ChatRoom (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • createDt (Field) — LocalDateTime
  • User.id (Key2) — String — Foreign key → User.id — NOT NULL
  • Company.id (Key3) — Long — Foreign key → Company.id — NOT NULL

Company (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (Field10) — String
  • password (Field) — String
  • name (Field2) — String
  • region (Field3) — Region
  • postalCode (Field5) — String
  • baseAddress (Field11) — String
  • detailAddress (Field4) — String
  • intro (Field6) — String
  • telNum (Field7) — String
  • openTime (Field8) — int
  • closeTime (Field9) — int
  • notification (Field12) — String
  • latitude (Field13) — double
  • longitude (Field14) — double
  • approved (Field15) — boolean

File (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • originalName (Field2) — String
  • ext (Field3) — FileExt
  • size (Field4) — Long
  • Company.main_id (Key6) — Long — Foreign key → Company.id — NOT NULL
  • Company.id (Key2) — Long — Foreign key → Company.id — NOT NULL
  • Buindle.id (Key4) — Long — Foreign key → Bundle.id — NOT NULL
  • Product.id (Key3) — Long — Foreign key → Product.id — NOT NULL
  • Supplement.id (Key5) — Long — Foreign key → Supplement.id — NOT NULL

Heart (CopyOfCopyOfCopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • User.id (Key2) — String — Foreign key → User.id — NOT NULL
  • Company.id (Key3) — Long — Foreign key → Company.id — NOT NULL
  • Supplement.id (Key4) — Long — Foreign key → Supplement.id — NOT NULL

Pay (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • Payment (Field) — Payment
  • card (Field2) — Card
  • installmentMonths (Field3) — int
  • payDt (Field4) — LocalDateTime
  • totalPrice (Field5) — int
  • Reservation.id (Key2) — Long — Foreign key → Reservation.id — NOT NULL

Pet (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • species (Field4) — Species
  • breed (Field) — String
  • name (Field2) — String
  • years (Field3) — int
  • months (Field5) — int
  • weight (Field6) — double
  • User.id (Key2) — String — Foreign key → User.id — NOT NULL

Product (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field2) — String
  • intro (Field3) — String
  • Bundle.id (Key3) — Long — Foreign key → Bundle.id — NOT NULL

Reservation (CopyOfCopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • date (Field) — LocalDate
  • time (Field2) — int
  • User.id (Key5) — String — Foreign key → User.id — NOT NULL
  • Pet.id (Key2) — Long — Foreign key → Pet.id — NOT NULL
  • Company.id (Key3) — Long — Foreign key → Company.id — NOT NULL
  • Bundle.id (Key4) — Long — Foreign key → Bundle.id — NOT NULL

Review (CopyOfCopyOfCopyOfCopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • rating (Field) — int
  • content (Field2) — String
  • writeDt (Field3) — LocalDateTime
  • Reservation.id (Key2) — Long — Foreign key → Reservation.id — NOT NULL
  • Company.id (Key5) — Long — Foreign key → Company.id — NOT NULL
  • Bundle.id (Key3) — Long — Foreign key → Bundle.id — NOT NULL

Search (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • word (Field) — String
  • createDt (Field2) — LocalDateTime
  • User.id (Key2) — String — Foreign key → User.id — NOT NULL

Supplement (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • intro (Field2) — String
  • price (Field3) — int
  • Company.id (Key2) — Long — Foreign key → Company.id — NOT NULL

Supplement_Reservation (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • Supplement.id (Key2) — Long — Foreign key → Supplement.id — NOT NULL
  • Reservation.id (Key3) — Long — Foreign key → Reservation.id — NOT NULL

TimeOff (CopyOfUntitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • date (Field) — LocalDate
  • time (Field2) — int
  • Company.id (Key2) — String — Foreign key → Company.id — NOT NULL

User (사용자)

  • id (Key) — String — Primary key — NOT NULL
  • password (Field) — String
  • name (Field2) — String
  • phoneNum (Field3) — String
  • birthday (Field4) — LocalDate
  • gender (Field5) — Gender
  • postalCode (Field6) — String
  • baseAddress (Field7) — String
  • detailAddress (Field8) — String