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