web
Tables (9)
Comments
- id — INT
- email — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- noticeboard_id — INT
Message
- id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- create_id — BIGINT — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
Note
- id — INT
- sender — VARCHAR(255) — NOT NULL
- recipient — VARCHAR(255) — NOT NULL
Noticeboard
- id — INT
- email — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- like — INT
- count — INT
- active — INT — NOT NULL
members
- member_email — VARCHAR(255)
- member_password — VARCHAR(255) — NOT NULL
- member_name — VARCHAR(100) — NOT NULL
- age — INT
- member_contribution — INT
- member_role — ENUM('user', 'admin') — NOT NULL
- status — TINYINT
open_ai_conversation
- id — BIGINT
- create_time — DATETIME(6) — NOT NULL
- open_ai_conversation_create_id — BIGINT — NOT NULL
- member_email — VARCHAR(255) — NOT NULL
open_ai_message
- id — BIGINT
- content — VARCHAR(255) — NOT NULL
- message_type — ENUM('USER', 'ASSISTANT', 'SYSTEM', 'FUNCTION') — NOT NULL
- conversation_id — BIGINT — NOT NULL
report
- id — INT
- email — VARCHAR(255) — NOT NULL
- board — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
suggestion
- id — INT
- email — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL