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