test
Tables (4)
Category
- category_id (카테고리ID) — INT — Primary key — NOT NULL
- title (카테고리제목) — VARCHAR(255) — NOT NULL
- prompt (프롬포트메세지) — VARCHAR(255) — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
Diary
- diary_id (다이어리아이디) — INT — Primary key — NOT NULL
- user_id (유저아이디) — INT — Foreign key → User.user_id — NOT NULL
- content (내용) — VARCHAR(255) — NOT NULL
- question (랜덤질문) — VARCHAR(255) — NOT NULL
- answer (AI답변) — VARCHAR(255) — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
- year (년) — INT — NOT NULL
- month (월) — INT — NOT NULL
- day (일) — INT — NOT NULL
Survey
- survey_id (Key) — INT — Primary key — NOT NULL
- user_id (유저아이디) — INT — Foreign key → User.user_id — NOT NULL
- question (설문질문) — VARCHAR(255) — NOT NULL
- Field (별점) — INT
- response (설문대답) — INT — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
User
- user_id (유저아이디) — INT — Primary key — NOT NULL
- id (아아디) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- nickname (닉네임) — VARCHAR(255) — NOT NULL
- created_date (생성일) — DATETIME — NOT NULL
- role (역할) — VARCHAR(255) — NOT NULL