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