gpt-diary
Tables (4)
chat (채팅 내용)
- id (pk) — INT — Primary key — NOT NULL
- user_id (사용자 id) — INT — Foreign key → user.id — NOT NULL
- content (내용) — VARCHAR
- created_at (채팅 시각) — DATETIME
- diary_id (일기id) — INT — Foreign key → diary.id — NOT NULL
diary (일기)
- id (pk) — INT — Primary key — NOT NULL
- user_id (사용자 id) — INT — Foreign key → user.id — NOT NULL
- content (내용) — TEXT
- date (날짜) — DATE
- created_at (생성일) — TIMESTAMP
plan (일정)
- id (pk) — INT — Primary key — NOT NULL
- user_id (작성자 id) — INT — Foreign key → user.id — NOT NULL
- content (일정 내용) — VARCHAR(255)
- date (날짜) — DATE
- start (시작 시각) — TIME
- end (종료 시각) — TIME
- diary_id (일기장 id) — INT — Foreign key → diary.id — NOT NULL
user (사용자)
- id (pk) — INT — Primary key — NOT NULL
- password (비밀번호) — CHAR(64)