Delivery-Friends

Tables (28)

Copy Of Untitled (dislikePost)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — Long — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled2 (dislike_post_reply)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (post_reply_id) — Long — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled3 (ChoiceOption)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (count) — Long
  • Key (menu_option_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (choice_menu_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (ReviewMedia)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (review_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (file_name) — varchar(255)

Untitled (Cart)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (like_reply)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (post_reply_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (likePost)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Team)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (group_end_time) — LocalDateTime
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (pay)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (pay_status) — varchar(255)
  • Field (payment_method) — varchar(255)
  • Field (card_number) — varchar(255)
  • Field (account_number) — varchar(255)
  • Field (tel_number) — varchar(255)
  • Field (price) — Long

Untitled (TeamOrder)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (is_leader) — boolean
  • Field (order_status)
  • Key (group_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (cart_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (participants)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (board_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (post_reply)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (content) — varchar(255)
  • Key (post_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (post)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (title) — varchar(255)
  • Field (content) — varchar(255)
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (region1depthName) — varchar(255)
  • Field (region2depthName) — varchar(255)
  • Field (region3depthName) — varchar(255)
  • Field (like_count) — Long
  • Field (dislike_count) — Long

Untitled (re_review)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (content) — Text
  • Key (review_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (User)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (nickname) — varchar(255)
  • Field (birth) — LocalDate
  • Field (email) — varchar(255)
  • Field (password) — varchar(255)
  • Field (region1depthName) — varchar(255)
  • Field (region2depthName) — varchar(255)
  • Field (region3depthName) — varchar(255)
  • Field (kakaoId) — varchar(255)
  • Field (gender) — varchar(255)
  • Field (point) — varchar(255)
  • Key (group_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (review)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (content) — Text
  • Field (score) — Long
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (order_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (choiceMenu)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (count) — Long
  • Key (menu_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (cart_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (MenuMedia)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (menu_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (file_name) — varchar(255)

Untitled (StoreMedia)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (file_name) — varchar(255)

Untitled (MenuOptionGroup)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (multi_select) — Long
  • Key (menu_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (StoreCategory)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Category)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)

Untitled (MenuOption)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (price) — Long
  • Field (max_count) — Long
  • Key (menu_option_group_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (default_value) — Long

Untitled (Menu)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (price) — Long
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (expression) — varchar(255)

Untitled (UserOrder)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (result) — varchar(255)
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (order_info) — varchar(255)
  • Field (paymentKey) — varchar(255)
  • Key (team_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (likeStore)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (Store)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar(255)
  • Field (region1depthName) — varchar(255)
  • Field (region2depthName) — varchar(255)
  • Field (region3depthName) — varchar(255)
  • Field (phone_number) — varchar(255)
  • Field2 (intro) — varchar(255)
  • Field (open_time) — LocalTime
  • Field (close_time) — LocalTime
  • Field (registration_number) — varchar(255)
  • Field (delivery_wait_time) — Long
  • Field (package_Available) — Boolean
  • Field (package_wait_time) — Long
  • Field (delivery_tip) — Long

Untitled (BaseEntity)

  • Field (create_date) — LocalDateTime
  • Field (modified_date) — LocalDateTime
  • Field (status) — Boolean