주문플랫폼 (수정)

테이블 (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