cocoh
Tables (4)
img
- img_id — INT — Primary key
- file_name — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- alt_text — VARCHAR(255)
- uploaded_by — INT
- uploaded_at — DATETIME
page_content
- id — INT
- route — VARCHAR(100)
- content — TEXT
- img_id — INT
- order_num — INT
slider
- id — INT
- title — VARCHAR(100)
- img_id — INT
- order_num — INT
user
- user_id (Key) — INT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(50) — NOT NULL
- created_at — DATETIME