웹서버 5조
테이블 (9)
comment
- comment_id — INT
- post_id — INT — NOT NULL
- users_id — INT — NOT NULL
- content — varchar(255) — NOT NULL
- created_at — TIMESTAMP
data_cache
- data_id — INT
- source — VARCHAR(100)
- data_type — VARCHAR(50)
- content — JSON
- fetched_at — TIMESTAMP
exercise
- exercise_id — INT
- users_id — INT — NOT NULL
- name — VARCHAR(100)
- category — VARCHAR(50)
- calories — INT
health
- health_id — INT
- users_id — INT — NOT NULL
- exercise_id — INT — NOT NULL
- duration_min — INT — NOT NULL
- total_calories — INT — NOT NULL
- date — DATE
interest
- interest_id — INT
- users_id — INT — NOT NULL
- category — VARCHAR(50)
- score — INT
news
- news_id — INT
- users_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- summary — TEXT
- image_url — VARCHAR(255)
- url — VARCHAR(255) — NOT NULL
- category — VARCHAR(50)
- publisher — VARCHAR(100)
- published_at — DATETIME
- crawled_at — TIMESTAMP
post
- post_id — INT
- users_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — varchar(255) — NOT NULL
- created_at — TIMESTAMP
recommend
- recommend_id — INT
- users_id — INT — NOT NULL
- news_id — INT
- recommended_at — TIMESTAMP
- type — ENUM('AI', 'General')
- clicked — CHAR(1)
- liked — CHAR(1)
users
- id — INT
- user_id — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(20)
- service_agreed — CHAR(1)
- location_agreed — CHAR(1)
- service_type — enum
- division — varchar(255) — NOT NULL
- unit — varchar(255) — NOT NULL
- enlist_date — date — NOT NULL
- img_url — varchar(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP