주문플랫폼 (수정)
테이블 (11)
p_cart (Untitled4)
- cart_id (PK) — VARCHAR — 기본 키 — NOT NULL
- created_by (Field) — VARCHAR
- created_at (Field2) — TIMESTAMP
- updated_by (Field3) — VARCHAR
- updated_at (Field4) — TIMESTAMP
- deleted_by (Field5) — VARCHAR
- deleted_at (Field6) — TIMESTAMP
- is_deleted (Field7) — BOOLEAN
- user_id (FK) — UUID — 외래 키 → p_user.user_id — NOT NULL
p_cart_item (Untitled7)
- cart_item_id (PK) — UUID — 기본 키 — NOT NULL
- quantity (Field) — INTEGER
- price (Field2) — INTEGER
- created_by (Field3) — VARCHAR(50)
- created_at (Field4) — TIMESTAMP
- updated_by (Field5) — VARCHAR(50)
- updated_at (Field6) — TIMESTAMP
- deleted_by (Field7) — VARCHAR(50)
- deleted_at (Field8) — TIMESTAMP
- product_id (FK) — UUID — 외래 키 → p_product.product_id — NOT NULL
- cart_id (FK2) — VARCHAR — 외래 키 → p_cart.cart_id — NOT NULL
- is_deleted (Field9) — BOOLEAN
p_order (Untitled)
- order_id (PK) — UUID — 기본 키 — NOT NULL
- type (field2) — VARCHAR(10)
- status (Field3) — VARCHAR(10)
- requests (Field4) — VARCHAR(50)
- total_price (Field5) — VARCHAR
- created_by (Field6) — VARCHAR
- created_at (Field) — VARCHAR
- updated_by (Field2) — VARCHAR
- updated_at (Field7) — VARCHAR
- deleted_by (Field8) — VARCHAR
- deleted_at (Field9) — VARCHAR
- user_id (FK) — UUID — 외래 키 → p_user.user_id — NOT NULL
- store_id (FK2) — UUID — 외래 키 → p_store.store_id — NOT NULL
- is_deleted (Field10) — BOOLEAN
p_order_item (Untitled2)
- order_item_id (PK) — UUID — 기본 키 — NOT NULL
- quantity (Field2) — INTEGER
- item_price (Field3) — VARCHAR
- created_by (Field4) — VARCHAR
- created_at (Field5) — VARCHAR
- updated_by (Field6) — VARCHAR
- updated_at (Field7) — VARCHAR
- deleted_by (Field8) — VARCHAR
- deleted_at (Field) — VARCHAR
- order_id (FK) — UUID — 외래 키 → p_order.order_id — NOT NULL
- product_id (FK2) — UUID — 외래 키 → p_product.product_id — NOT NULL
- is_deleted (Field9) — BOOLEAN
p_payment (Untitled6)
- payment_id (PK) — UUID — 기본 키 — NOT NULL
- bank (Field) — VARCHAR(100)
- state (Field2) — VARCHAR(100)
- price (Field3) — INT
- created_by (Field4) — VARCHAR(50)
- created_at (Field5) — TIMESTAMP
- updated_by (Field6) — VARCHAR(50)
- updated_at (Field7) — TIMESTAMP
- deleted_by (Field8) — VARCHAR(50)
- deleted_at (Field9) — TIMESTAMP
- order_id (FK) — UUID — 외래 키 → p_order.order_id — NOT NULL
- is_deleted (Field10) — BOOLEAN
p_product (Untitled5)
- product_id (PK) — UUID — 기본 키 — NOT NULL
- name (Field1) — VARCHAR(100)
- price (Field2) — INTEGER
- description (Field3) — VARCHAR(100)
- created_by (Field4) — VARCHAR(100)
- created_at (Field5) — TIMESTAMP
- updated_by (Field6) — VARCHAR(100)
- updated_at (Field7) — TIMESTAMP
- deleted_by (Field8) — VARCHAR(100)
- deleted_at (Field9) — TIMESTAMP
- store_id (FK) — UUID — 외래 키 → p_store.store_id — NOT NULL
- quantity (Field10) — INTEGER
- is_deleted (Field11) — BOOLEAN
p_review (Untitled9)
- review_id (PK) — UUID — 기본 키 — NOT NULL
- rating (Field) — INTEGER
- content (Field2) — TEXT
- created_by (Field3) — VARCHAR
- created_at (Field4) — TIMESTAMP
- updated_by (Field5) — VARCHAR
- updated_at (Field6) — TIMESTAMP
- deleted_by (Field7) — VARCHAR
- deleted_at (Field8) — TIMESTAMP
- order_id (FK) — UUID — 외래 키 → p_order.order_id — NOT NULL
- is_deleted (Field9) — BOOLEAN
p_store (Untitled8)
- store_id (PK) — UUID — 기본 키 — NOT NULL
- name (Field) — VARCHAR(100)
- state (Field2) — VARCHAR(10)
- number (Field3) — VARCHAR(20)
- description (Field5) — TEXT
- min_order_price (Field6) — INT
- delivery_fee (Field7) — INT
- rating (Field8) — FLOAT
- review_count (Field9) — INT
- created_by (Field10) — VARCHAR
- created_at (Field11) — TIMESTAMP
- updated_by (Field12) — VARCHAR
- updated_at (Field13) — TIMESTAMP
- deleted_by (Field14) — VARCHAR
- deleted_at (Field15) — TIMESTAMP
- user_id (FK) — UUID — 외래 키 → p_user.user_id — NOT NULL
- is_deleted (Field16) — BOOLEAN
p_store_address (Untitled3)
- address_id (PK) — UUID — 기본 키 — NOT NULL
- city (Field) — VARCHAR
- district (Field2) — VARCHAR
- load_name (Field3) — VARCHAR
- zip_code (Field4) — VARCHAR
- detail (Field5) — VARCHAR
- created_by (Field6) — TIMESTAMP
- is_deleted (Field7) — BOOLEAN
- store_id (FK) — UUID — 외래 키 → p_store.store_id — NOT NULL
p_user
- user_id (PK) — UUID — 기본 키 — NOT NULL
- username (Field1) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- nickname (Field3) — VARCHAR(50)
- phone_number (Field4) — VARCHAR(50)
- role (Field5) — VARCHAR
- grade (Field6) — VARCHAR(50)
- created_by (Field7) — VARCHAR
- created_at (Field8) — TIMESTAMP
- deleted_by (Field9) — TIMESTAMP
- deleted_at (Field10) — TIMESTAMP
- updated_by (Field11) — VARCHAR
- updated_at (Field12) — TIMESTAMP
- email (Field13) — VARCHAR(50)
- is_deleted (Field14) — BOOLEAN
p_user_address (CopyOfUntitled3)
- address_id (PK) — UUID — 기본 키 — NOT NULL
- city (Field) — VARCHAR
- district (Field2) — VARCHAR
- load_name (Field3) — VARCHAR
- zip_code (Field4) — VARCHAR
- detail (Field5) — VARCHAR
- created_by (Field6) — TIMESTAMP
- is_deleted (Field7) — BOOLEAN
- user_id (FK) — UUID — 외래 키 → p_user.user_id — NOT NULL