ai-odyssey

Tables (4)

ai-service-list (ai-list-table)

  • id — BIGINT — Primary key — NOT NULL — ai service item
  • 제목 (title) — CHAR(30) — NOT NULL — ai service title
  • 설명 (txt) — TEXT(255) — NOT NULL — ai service text
  • 평점 (grade) — TINYINT(5) — ai service grade

comment (comment-table)

  • id — BIGINT — Primary key — NOT NULL — comment id
  • notice id (id2) — BIGINT — Foreign key → notice.notice id — NOT NULL — notice id
  • id (id22) — BIGINT — Foreign key → notice.id — NOT NULL — user id
  • 댓글 내용 (content) — VARCHAR(255) — NOT NULL — comment contents
  • 생성 날짜 (createDate) — TIMESTAMP — NOT NULL — comment create date

notice (notice-table)

  • notice id (id) — BIGINT — Primary key — NOT NULL — notice id
  • id (id2) — BIGINT — Foreign key → user.id — NOT NULL — user id
  • 제목 (title) — CHAR(30) — NOT NULL — notice title
  • 내용 (content) — VARCHAR(65535) — NOT NULL — notice content
  • 해시태그 (hashtag) — VARCHAR(255) — hashtag
  • 생성 날짜 (createDate) — TIMESTAMP — NOT NULL — notice create date

user (user-table)

  • id — BIGINT — Primary key — NOT NULL — user id
  • 이메일 (email) — VARCHAR(30) — NOT NULL — user email
  • 비밀번호 (password) — VARCAHR(100) — NOT NULL — user pw
  • 닉네임 (nickname) — VARCHAR(50) — NOT NULL — user name
  • 생일 (birth) — DATE — NOT NULL — user birth