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)