Bitcafe

Tables (8)

Cart (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • orderItemList (메뉴정보리스트) — List<OrderItem>
  • Field
  • id (Key2) — Long — Foreign key → Menu.id — NOT NULL
  • id (Key3) — Long — Foreign key → Member.id — NOT NULL

Category (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • categoryName (카테고리명) — String
  • imagePath (이미지 경로) — String

Member (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • nickname (아이디) — String
  • password (비밀번호) — String
  • email (이메일) — String
  • phoneNumber (전화번호) — String
  • isDeleted (탈퇴여부) — boolean

Menu (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • menuName (메뉴) — String
  • menuContent (설명) — String
  • menuPrice (가격) — Integer
  • imagePath (이미지 경로) — String
  • id (Key2) — Long — Foreign key → Category.id — NOT NULL

Order (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • orderPrice (Field)
  • id (Key2) — long — Foreign key → Store.id — NOT NULL
  • id (Key3) — Long — Foreign key → Member.id — NOT NULL

OrderDetail (Untitled8)

  • id (Key) — Long — Foreign key → Menu.id — NOT NULL
  • id (Key2) — Long — Foreign key → Order.id — NOT NULL

Store (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • storeName (매장명) — String
  • storeAddr (매장주소) — String
  • lat (위도) — Double
  • lng (경도) — Double
  • storePhone (매장번호) — String
  • imagePath (이미지 경로) — String

Transaction (Untitled7)

  • Key — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → Order.id — NOT NULL