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