next-day-delivery
Tables (11)
order_detail
- order_id — UUID — Primary key — NOT NULL
- product_id — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — TIMESTAMP
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
- order_id2 — UUID — Foreign key → p_order.order_id — NOT NULL
- product_id2 — UUID — Foreign key → p_product.product_id — NOT NULL
p_category
- category_id — UUID — Primary key — NOT NULL
- category_name — VARCHAR(100)
p_location
- loc_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
- name — VARCHAR(100)
- parent_id — VARCHAR(100)
- depth — VARCHAR(100)
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
p_order
- order_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
- order_status — ENUM
- address — VARCHAR()
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — TIMESTAMP
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
p_payment
- payment_id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → p_order.order_id — NOT NULL
- payment_method — ENUM
- pament_state — ENUM
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
p_product
- product_id — UUID — Primary key — NOT NULL
- store_id — UUID — Foreign key → p_store.store_id — NOT NULL
- product_name — VARCHAR(100)
- price — INT
- is_public — BOOLEAN
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
p_response
- res_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
- content — TEXT
p_review
- review_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
- order_id — UUID — Foreign key → p_order.order_id — NOT NULL
- store_id — UUID — Foreign key → p_store.store_id — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
p_store
- store_id — UUID — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → p_user.user_id — NOT NULL
- name — VARCHAR(100)
- rating_avg — DECIMAL(2,1)
- Field — VARCHAR(255)
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)
p_store_category
- category_id — UUID — Foreign key → p_category.category_id — NOT NULL
- store_id — UUID — Foreign key → p_store.store_id — NOT NULL
p_user
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(100)
- nickname — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(255)
- role — ENUM
- is_public — BOOLEAN
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
- updated_at — TIMESTAMP
- updated_by — VARCHAR(100)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(100)