NewSive_ERD
Tables (8)
ChatMessage
- id — INT — Primary key
- room_id — INT — NOT NULL
- user_id — INT — NOT NULL
- message — TEXT
- created_at — DATETIME
ChatRoom
- id — INT — Primary key
- name — VARCHAR(255)
- created_at — DATETIME
Friend
- id — INT — Primary key
- user_id — INT — NOT NULL
- friend_user_id — INT — NOT NULL
- created_at — DATETIME
News
- id — INT — Primary key
- title — VARCHAR(255) — NOT NULL
- summary — TEXT
- thumbnail_url — VARCHAR(500)
- published_at — DATETIME
- original_link — VARCHAR(500)
- created_at — DATETIME
Notification
- id — INT — Primary key
- user_id — INT — NOT NULL
- news_id — INT
- message — VARCHAR(255)
- is_read — BOOLEAN
- created_at — DATETIME
User
- id — INT — Primary key
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255)
- birthday — DATE
- gender — ENUM('male','female','other')
- created_at — DATETIME
- updated_at — DATETIME
UserSetting
- id — INT — Primary key
- user_id — INT — NOT NULL
- allow_notification — BOOLEAN
- keywords — TEXT
- updated_at — DATETIME
Weather
- id — INT — Primary key
- location — VARCHAR(255)
- temperature — FLOAT
- humidity — FLOAT
- status — VARCHAR(100)
- updated_at — DATETIME