test

Tables (21)

menu_cart

  • uuid — varchar(255) — NOT NULL
  • menu_cart_quantity — integer — NOT NULL
  • menu_cart_total_price — integer — NOT NULL
  • cart_carts_uuid — varchar(255)
  • menu_menu_uuid — uuid

p_cart

  • carts_uuid — varchar(255) — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • cart_is_deleted — boolean
  • total_price — integer
  • total_quantity — integer
  • user_id — bigint

p_delivery

  • delivery_id — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • delivery_cancel_reason — varchar(255)
  • delivery_address — varchar(255)
  • delivery_estimated_time — timestamp(6)
  • delivery_memo — varchar(255)
  • delivery_start_time — timestamp(6)
  • delivery_status — varchar(255)
  • ASSIGNED::character — varying
  • PICKUP::character — varying
  • DELIVERING::character — varying
  • COMPLETED::character — varying
  • CANCELED::character — varying)::text))

p_location

  • location_uuid — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • address — varchar(255) — NOT NULL
  • zipcode — varchar(10) — NOT NULL
  • location_category_id — integer — NOT NULL

p_manager

  • id — bigint
  • store_uuid — uuid
  • user_id — bigint

p_master

  • master_id — bigint
  • master_master_code — varchar(255)

p_menus

  • menu_uuid — uuid — NOT NULL
  • food_image — varchar(255)
  • menu_availability — boolean — NOT NULL
  • menu_description — varchar(255)
  • menu_name — varchar(255) — NOT NULL
  • menu_price — integer — NOT NULL
  • store_id — uuid — NOT NULL

p_operation_times

  • store_operating_times_uuid — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • operation_times_is_holiday — boolean — NOT NULL
  • operation_times_closing_time — varchar(255) — NOT NULL
  • operation_times_opening_time — varchar(255) — NOT NULL
  • weekday — integer — NOT NULL

p_order

  • order_uuid — varchar(255) — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • order_order_type — varchar(255)
  • order_order_status — varchar(255)
  • DELIVERING::character — varying
  • CANCELED::character — varying)::text))
  • order_total_price — integer
  • order_total_quantity — integer
  • delivery_id — uuid
  • store_id — uuid

p_order_menu

  • orders_menus_uuid — varchar(255) — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • order_menu_quantity — integer
  • order_menu_total_price — integer

p_owner

  • id — bigint
  • store_uuid — uuid
  • user_id — bigint

p_payment

  • payment_id — uuid — NOT NULL
  • payment_amount — numeric(38, 2)
  • canceled_at — timestamp(6)
  • payment_is_deleted — boolean
  • paid_at — timestamp(6)
  • payment_method — varchar(255)
  • payment_status — varchar(255)
  • COMPLETED::character — varying
  • CANCELLED::character — varying)::text))
  • payment_transaction_id — varchar(255)
  • order_order_uuid — varchar(255)

p_review

  • review_id — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • content — varchar(255)
  • review_is_deleted — boolean
  • rating — double
  • menu_uuid — uuid
  • order_id — varchar(255)
  • store_uuid — uuid
  • user_id — bigint

p_review_image

  • review_image_id — varchar(255) — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • image_name — varchar(255)
  • image_size — bigint
  • image_url — varchar(255)
  • review_image_is_deleted — boolean
  • review_id — uuid

p_seoul_area_code

  • seoul_area_code_id — integer — NOT NULL
  • area_name — varchar(50) — NOT NULL

p_store

  • store_uuid — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • phone_number — varchar(100) — NOT NULL
  • store_description — varchar(255)
  • store_is_deleted — boolean
  • store_is_granted — boolean
  • store_name — varchar(100) — NOT NULL
  • store_category_id — integer
  • store_location_uuid — uuid

p_store_category

  • store_category_id — integer — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • store_category — varchar(255) — NOT NULL

p_store_location

  • store_location_uuid — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • location_uuid — integer

p_store_operation_times

  • store_operation_times_uuid — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • operation_times_uuid — uuid — NOT NULL
  • store_uuid — uuid — NOT NULL

p_user

  • user_id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • modified_at — timestamp(6)
  • modified_by — varchar(255)
  • user_birth_date — date — NOT NULL
  • user_first_name — varchar(255) — NOT NULL
  • user_gender — varchar(255) — NOT NULL
  • FEMALE::character — varying)::text))
  • user_is_deleted — boolean
  • user_is_public — boolean — NOT NULL
  • user_last_name — varchar(255) — NOT NULL
  • user_nickname — varchar(255) — NOT NULL
  • user_password — varchar(255) — NOT NULL
  • user_phone_number — varchar(255) — NOT NULL
  • user_profile_image — varchar(255)
  • user_token_issued_at — timestamp(6)
  • user_role — varchar(255) — NOT NULL
  • MASTER::character — varying
  • OWNER::character — varying
  • MANAGER::character — varying)::text))
  • user_username — varchar(255) — NOT NULL
  • master_id — bigint

p_user_store

  • uuid — varchar(255) — NOT NULL
  • store_store_uuid — uuid
  • user_user_id — bigint