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