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