Shop
Tables (9)
auth (Untitled8)
- id (PK) — UUID — Primary key — NOT NULL
- user_id (FK) — UUID — Foreign key → user.id — NOT NULL
- user_email (Field8) — VARCHAR(255)
- password_hash (Field) — VARCHAR(255)
- oauth_provider (Field2) — VARCHAR(50)
- oauth_provider_id (Field3) — VARCHAR(255)
- refresh_token (Field4) — VARCHAR(500)
- refresh_token_expires_at (Field5) — TIMESTAMP
- created_at (Field6) — TIMESTAMP
- updated_at (Field7) — TIMESTAMP
cart (Untitled9)
- id (PK) — UUID — Primary key — NOT NULL
- user_id (FK) — UUID — Foreign key → user.id — NOT NULL
- id (PK2) — UUID — Foreign key → product.id — NOT NULL
- - — - — Foreign key → product.category_id — NOT NULL
- product_id (Field) — UUID
- quantity (Field2) — INT4
- created_at (Field3) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
category (Untitled2)
- id (PK) — UUID — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
option (Untitled5)
- id (PK) — UUID — Primary key — NOT NULL
- size (Field) — VARCHAR(10)
- color (Field2) — VARCHAR(50)
- additional_price (Field3) — INT4
- stock_quantity (Field4) — INT4
- Field5
product (Untitled)
- id (PK) — UUID — Primary key — NOT NULL
- category_id (FK) — UUID — Foreign key → category.id — NOT NULL
- name (Field) — VARCHAR(150)
- name_en (Field6) — VARCHAR(150)
- description (Field2) — VARCHAR(300)
- price (Field3) — INT4
- status (Field4) — VARCHAR(50)
- thumbnail_url (Field5) — VARCHAR(1000)
- created_at (Field7) — TIMESTAMP
- updated_at (Field8) — TIMESTAMP
product_option (Untitled6)
- id (PK) — UUID — Primary key — NOT NULL
- product_id (FK2) — UUID — Foreign key → product.id — NOT NULL
- option_id (FK) — UUID — Foreign key → option.id — NOT NULL
- - — - — Foreign key → product.category_id — NOT NULL
product_subcategory (Untitled4)
- id (PK) — UUID — Primary key — NOT NULL
- product_id (FK) — UUID — Foreign key → product.id — NOT NULL
- subcategory_id (FK2) — UUID — Foreign key → subcategory.id — NOT NULL
- - — - — Foreign key → product.category_id — NOT NULL
subcategory (Untitled3)
- id (PK) — UUID — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- created_at (Field2) — TIMESTAMP
- updated_at (Field3) — TIMESTAMP
user (Untitled7)
- id (PK) — UUID — Primary key — NOT NULL
- nickname (Field) — VARCHAR(80)
- email (Field2) — VARCHAR(255)
- phone (Field3) — VARCHAR(30)
- marketing_agreed (Field4) — BOOL
- status (Field5) — VARCHAR(32)
- role (Field6) — VARCHAR(32)
- created_at (Field7) — TIMESTAMP
- updated_at (Field8) — TIMESTAMP
- deleted_at (Field9) — TIMESTAMP