누떡
테이블 (11)
AIChatMessage
- id — INT — 기본 키 — NOT NULL
- sessionId — INT — 외래 키 → AIChatSession.id — NOT NULL
- userid (userId) — INT — 외래 키 → AIChatSession.userid — NOT NULL
- message — TEXT — NOT NULL
- sender — ENUM('user', 'ai') — NOT NULL
- createdAt — TIMESTAMP
AIChatSession
- id — INT — 기본 키 — NOT NULL
- userid (userId) — INT — 외래 키 → User.id — NOT NULL
- topic — VARCHAR(255)
- createdAt — TIMESTAMP
Category
- category_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(255)
Community
- post_id — INT — 기본 키
- user_id — INT — 외래 키 → User.id — NOT NULL
- category_id — INT — 외래 키 → Category.category_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- likes_count — INT
- views_count — INT
- comments_count — INT
EnglishSentences
- id — INT — 기본 키 — NOT NULL
- english — TEXT
- korean — TEXT
- note — TEXT
Expert
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- job_title — VARCHAR(255) — NOT NULL
- age — INT — NOT NULL
- bio — TEXT
- profile_image — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(50)
- cost — DECIMAL(10, 2)
- hashtags — VARCHAR(255)
LifeGraph
- graph_id — INT — 기본 키 — NOT NULL
- userId — INT — 외래 키 → User.id — NOT NULL
- events — JSON
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Quotes
- id — INT — 기본 키 — NOT NULL
- author — TEXT
- authorProfile — TEXT
- message — TEXT
User
- id — INT — 기본 키 — NOT NULL
- provider — VARCHAR(255) — NOT NULL
- providerId — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- refreshToken — VARCHAR(255)
- imageUrl — VARCHAR(255)
- createdAt — DATETIME
- updatedAt — DATETIME
- deletedAt — DATETIME
UserHashtag
- hashtagid (id) — INT — 기본 키 — NOT NULL
- userId — BIGINT — 외래 키 → User.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
comments
- id — INT — 기본 키 — NOT NULL
- user_id (user_id2) — INT — 외래 키 → Community.user_id — NOT NULL
- post_id — INT — 외래 키 → Community.post_id
- category_id — INT — 외래 키 → Community.category_id — NOT NULL
- parent_id — INT
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP