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