배달펑

테이블 (8)

CATALOG (Untitled7)

  • catalog_id (Key) — UUID — 기본 키 — NOT NULL
  • catalog_name (Field) — VARCHAR(100) — NOT NULL

CATEGORIES (Untitled4)

  • category_id (Key) — UUID — 기본 키 — NOT NULL
  • category_name (Field) — VARCHAR(100) — NOT NULL

ORDERS (Untitled3)

  • order_id (Key) — UUID — 기본 키 — NOT NULL
  • order_date (Field) — TIMESTAMP
  • order_state (Field2) — VARCHAR(20)
  • total_amount (Field3) — DECIMAL(10,2)
  • total_quantity (Field4) — INT
  • shipping_address (Field5) — VARCHAR(100)
  • user_id (유저아이디) — BIGINT — 외래 키 → USERS.user_id — NOT NULL
  • store_id (Key2) — UUID — 외래 키 → STORES.store_id — NOT NULL

ORDER_DETAILS (Untitled5)

  • order_detail_id (Key) — UUID — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR(255)
  • quantity (Field2) — INT
  • unit_price (Field3) — DEMICAL(10,2)
  • subtotal (Field4) — DEMICAL(10,2)
  • order_id (Key2) — UUID — 외래 키 → ORDERS.order_id — NOT NULL
  • product_id (key) — UUID — 외래 키 → PRODUCTS.product_id — NOT NULL

PAYMENTS (Untitled6)

  • payment_id (Key) — UUID — 기본 키 — NOT NULL
  • payment_method (Field) — VARCHAR(100) — NOT NULL
  • card_number (Field2) — VARCHAR(100) — NOT NULL
  • payment_state (Field3) — VARCHAR(20) — NOT NULL
  • total_amount (Field4) — DEMICAL(10,2) — NOT NULL
  • payment_date (Field5) — TIMESTAMP — NOT NULL
  • user_id (유저아이디) — BIGINT — 외래 키 → USERS.user_id — NOT NULL
  • order_id (Key2) — UUID — 외래 키 → ORDERS.order_id — NOT NULL

PRODUCTS (Untitled2)

  • product_id (key) — UUID — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR(100) — NOT NULL
  • product_price (Field2) — NUMERIC — NOT NULL
  • product_detail (Field3) — TEXT
  • product_img_url (Field4) — VARCHAR(300)
  • store_id (Key) — UUID — 외래 키 → STORES.store_id — NOT NULL
  • category_id (Key2) — UUID — 외래 키 → CATEGORIES.category_id — NOT NULL

STORES (Untitled8)

  • store_id (Key) — UUID — 기본 키 — NOT NULL
  • store_name (Field) — VARCHAR(100) — NOT NULL
  • store_phone (Field2) — VARCHAR(255)
  • store_address (Field3) — VARCHAR(255)
  • store_detail (Field4) — TEXT
  • catalog_id (Key2) — UUID — 외래 키 → CATALOG.catalog_id — NOT NULL

USERS (Untitled)

  • user_id (유저아이디) — BIGINT — 기본 키 — NOT NULL
  • username (유저이름) — VARCHAR(255) — NOT NULL
  • nickname (유저닉네임) — VARCHAR(255) — NOT NULL
  • password (유저패스워드) — VARCHAR(255) — NOT NULL
  • email (유저이메일) — VARCHAR(255) — NOT NULL — unique