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