Query

data — Reward

SQL

CREATE TABLE "Reward"  (
  "id" integer PRIMARY KEY,
  "title" text NOT NULL,
  "description_fr" text,
  "price" integer NOT NULL,
  "position" integer NOT NULL,
  "is_available" integer NOT NULL,
  "is_featured" integer NOT NULL,
  "shipping_type" text,
  "date_delivery" text,
  "phone_number_required" integer NOT NULL,
  "stock" integer,
  "stock_available" integer
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
description_fr TEXT ✓ Rename | Drop
price INTEGER Rename | Drop
position INTEGER Rename | Drop
is_available INTEGER Rename | Drop
is_featured INTEGER Rename | Drop
shipping_type TEXT ✓ Rename | Drop
date_delivery TEXT ✓ Rename | Drop
phone_number_required INTEGER Rename | Drop
stock INTEGER ✓ Rename | Drop
stock_available INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?