cafe-lover

Tables (12)

admin (Untitled)

  • Long (Key) — PK — Primary key — NOT NULL
  • String (Field) — FIELD
  • String (Field2) — FIELD
  • String (Field3) — FIELD
  • AdminLevel (Field4) — FIELD
  • AdminStatus (Field5) — FIELD

bookmark (Untitled8)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → collection.Long — NOT NULL

cafe (Untitled4)

  • Long (Key) — PK — Primary key — NOT NULL
  • Owner (Key2) — FK — Foreign key → owner.Long — NOT NULL
  • List<CafeTag> (Field6) — FK
  • List<Review> (Field7) — FK
  • List<Menu> (Field8) — FK
  • List<CafePhoto> (Field9) — FK
  • String (Field) — FIELD
  • String (Field2) — FIELD
  • int (Field3) — FIELD
  • Location (Field4) — EMBEDDED
  • CafeStatus (Field5) — ENUMERATED

cafe_menu (Untitled10)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → cafe.Long — NOT NULL
  • String (Field) — FIELD
  • int (Field2) — FIELD

cafe_photo (Untitled11)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → cafe.Long — NOT NULL
  • String (Field) — FIELD

cafe_tag (Untitled6)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → cafe.Long — NOT NULL
  • Long (Key3) — FK — Foreign key → tag.Long — NOT NULL

collection (Untitled2)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → member.Long — NOT NULL
  • List<Bookmark> (Field) — FK

member (CopyOfUntitled5)

  • Long (Key) — PK — Primary key — NOT NULL
  • List<Review> (Field) — FK
  • List<Collection> (Field9) — FK
  • String (Field2) — FIELD
  • String (Field3) — FIELD
  • String (Field4) — FIELD
  • String (Field5) — FIELD
  • String (Field6) — FIELD
  • String (Field7) — FIELD
  • OwnerStatus (Field8) — ENUMERATED
  • MemberType (Field10) — ENUMERATED

owner (Untitled5)

  • Long (Key) — PK — Primary key — NOT NULL
  • List<Cafe> (Field) — FK
  • String (Field2) — FIELD
  • String (Field3) — FIELD
  • String (Field4) — FIELD
  • String (Field5) — FIELD
  • String (Field6) — FIELD
  • String (Field7) — FIELD
  • OwnerStatus (Field8) — ENUMERATED

review (Untitled3)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key3) — FK — Foreign key → cafe.Long — NOT NULL
  • Long (Key2) — FK — Foreign key → member.Long — NOT NULL
  • List<ReviewPhoto> (Field) — FK
  • String (Field2) — FIELD
  • Float (Field3) — FIELD
  • ReviewStatus (Field4) — ENUMERATED

review_photo (Untitled9)

  • Long (Key) — PK — Primary key — NOT NULL
  • Long (Key2) — FK — Foreign key → review.Long — NOT NULL
  • String (Field) — FIELD
  • String (Field2) — FIELD

tag (Untitled7)

  • Long (Key) — PK — Primary key — NOT NULL
  • String (Field) — FIELD