bogo
Tables (8)
Product (Untitled2)
- product_id (Key) — INT — Primary key — NOT NULL
- title (Field) — varchar(45)
- seller_id (Key2) — INT — Foreign key → users.id — NOT NULL
- image_url (Field3) — varchar(255)
- price (Field4) — INT
- product_states (Field6) — varchar(45)
- selled_at (Field5) — timestamp
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp
- category_id (Key3) — INT — Foreign key → category.category_id — NOT NULL
- views (Field10) — INT
category (Untitled4)
- category_id (Key) — INT — Primary key — NOT NULL
- name (Field) — varchar(45)
chat_messages (Untitled7)
- id (Key1) — INT — Primary key — NOT NULL
- sender (Key2) — INT — Foreign key → users.id — NOT NULL
- room_id (Field) — varchar(100)
- message (Field2) — text
- sent_at (Field3) — timestamp
- is_read (Field4) — tinyint(1)
chat_rooms (Untitled5)
- id (Key1) — INT — Primary key — NOT NULL
- room_id (Field) — varchar(100)
- user1 (Key2) — INT — Foreign key → users.id — NOT NULL
- user2 (Key3) — INT — Foreign key → users.id — NOT NULL
- created_at (Field2) — timestamp
- exited_user (Key4) — INT — Foreign key → users.id — NOT NULL
chat_users (Untitled6)
- auto_id (Key1) — INT — Primary key — NOT NULL
- id (Key2) — INT — Foreign key → users.id — NOT NULL
- nickname (Field) — varchar(50)
- created_at (Field2) — timestamp
keyword (Untitled8)
- keyword_id (Key1) — INT — Primary key — NOT NULL
- product_id (Key2) — INT — Foreign key → Product.product_id — NOT NULL
- labels (Field) — varchar(100)
- object (Field2) — varchar(255)
- logo (Field3) — varchar(20)
- text (Field4) — varchar(100)
- color (Field5) — datetime
users (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- username (Field) — varchar(100)
- userid (Field2) — varchar(100)
- password (Field3) — varchar(255)
- phone (Field4) — varchar(20)
- email (Field5) — varchar(100)
- created_at (Field6) — datetime
- last_login (Field7) — datetime
wishlist (Untitled3)
- wishlist_id (Key1) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → users.id — NOT NULL
- product_id (Key3) — INT — Foreign key → Product.product_id — NOT NULL
- created_at (Field) — INT