cocoh2

Tables (9)

business

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • title — VARCHAR(100)
  • content — TEXT
  • order_num — INT

contact_inquiry

  • inquiry_id — INT — Primary key
  • type — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(50)
  • phone — VARCHAR(50)
  • title — VARCHAR(50) — NOT NULL
  • message — VARCHAR(50) — NOT NULL
  • created_at — DATETIME

hairbear

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • title — VARCHAR(100)
  • content — TEXT
  • order_num — INT

history

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • title — VARCHAR(100)
  • content — TEXT
  • order_num — INT

img

  • img_id — INT — Primary key
  • file_name — VARCHAR(50) — NOT NULL
  • file_path — VARCHAR(50) — NOT NULL
  • alt_text — VARCHAR(255)
  • uploaded_by — INT
  • uploaded_at — DATETIME
  • user_id — INT — Foreign key → user.user_id

management

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • name — VARCHAR(100)
  • position — VARCHAR(100)
  • bio — TEXT
  • order_num — INT

news

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • title — VARCHAR(200)
  • content — TEXT
  • published_at — DATETIME
  • order_num — INT

partners

  • id — INT — Primary key
  • img_id (img_id2) — INT — Foreign key → img.img_id
  • partner_name — VARCHAR(100)
  • description — TEXT
  • order_num — INT
  • type — INT

user

  • user_id — INT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(50) — NOT NULL
  • created_at — DATETIME