school
Tables (6)
Chats (Untitled6)
- chat_id (Key) — INT — Primary key — NOT NULL
- order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL
- message (Field) — TEXT
- createdAt (Field2) — DATETIME
carts (Untitled3)
- user_id (id2) — INT — Foreign key → users.user_id — NOT NULL
- product_id (Key) — INT — Foreign key → products.product_id — NOT NULL
manners (Untitled5)
- user_id (id) — INT — Foreign key → users.user_id — NOT NULL
- manner (Field) — INT
orders (Untitled4)
- order_id (Key) — INT — Primary key — NOT NULL
- user_id (id) — INT — Foreign key → users.user_id — NOT NULL
- product_id (Key2) — INT — Foreign key → products.product_id — NOT NULL
- createdAt (Field4) — DATETIME
products (Untitled2)
- product_id (Key) — INT — Primary key — NOT NULL
- user_id (id) — INT — Foreign key → users.user_id — NOT NULL
- name (Field) — VARCHAR(45)
- price (Field2) — INT
- description (Field3) — TEXT
- producturl (Field4) — TEXT
- createdAt (Field5) — DATETIME
- area (Field6) — TEXT
users (Untitled)
- user_id (id) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR(45)
- password (Field2) — VARCHAR(128)
- name (Field3) — VARCHAR(128)
- email (Field4) — VARCHAR(128)