Classum
Tables (5)
Copy Of Copy Of Copy Of Copy Of templete (Chat)
- Key (chatIdx) — INT UNSIGNED AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL — 댓글 인덱스
- Key (writerIdx) — INT UNSIGNED — Foreign key → Copy Of templete.Key — NOT NULL — 작성자 인덱스
- Key (postIdx) — INT UNSIGNED — Foreign key → Copy Of Copy Of Copy Of templete.Key — NOT NULL — 게시글 인덱스
- Key (parentIdx) — INT UNSIGNED — Foreign key → Copy Of Copy Of Copy Of Copy Of templete.Key — 부모 인덱스
- Field (content) — varchar(100) — NOT NULL — 내용
- createdAt — TIMESTAMP — NOT NULL — 생성일시
- updatedAt — TIMESTAMP — NOT NULL — 수정일시
- status (deletedAt) — TIMESTAMP — 삭제일시
Copy Of Copy Of Copy Of templete (Post)
- Key (postIdx) — INT UNSIGNED AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL — 게시글 인덱스
- Key (userIdx) — INT UNSIGNED — Foreign key → Copy Of templete.Key — NOT NULL — 작성자 인덱스
- Key (spaceIdx) — INT UNSIGNED — Foreign key → Copy Of Copy Of templete.Key — NOT NULL — 공간 인덱스
- Field (title) — varchar(50) — NOT NULL — 제목
- Field (content) — varchar(1000) — NOT NULL — 내용
- createdAt — TIMESTAMP — NOT NULL — 생성일시
- updatedAt — TIMESTAMP — NOT NULL — 수정일시
- status (deletedAt) — TIMESTAMP — 삭제일시
Copy Of Copy Of Copy Of templete2 (User_Space)
- Key (userSpaceIdx) — INT UNSIGNED AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL — 유저-공간 인덱스
- Key (userIdx) — INT UNSIGNED — Foreign key → Copy Of templete.Key — NOT NULL — 유저 인덱스
- Key (spaceIdx) — INT UNSIGNED — Foreign key → Copy Of Copy Of templete.Key — NOT NULL — 공간 인덱스
- createdAt — TIMESTAMP — NOT NULL — 생성일시
- updatedAt — TIMESTAMP — NOT NULL — 수정일시
- status (deletedAt) — TIMESTAMP — 삭제일시
Copy Of Copy Of templete (Space)
- Key (spaceIdx) — INT UNSIGNED AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL — 공간 인덱스
- Key (ownerIdx) — INT UNSIGNED — Foreign key → Copy Of templete.Key — NOT NULL — 개설자 인덱스
- Field (name) — varchar(50) — NOT NULL — 공간 이름
- createdAt — TIMESTAMP — NOT NULL — 생성일시
- updatedAt — TIMESTAMP — NOT NULL — 수정일시
- status (deletedAt) — TIMESTAMP — 삭제일시
Copy Of templete (User)
- Key (userIdx) — INT UNSIGNED AUTO_INCREMENT PRIMARY KEY — Primary key — NOT NULL — 유저 인덱스
- Field (email) — varchar(50) — NOT NULL — 이메일
- Field (password) — text — NOT NULL — 비밀번호(해시)
- Field2 (firstName) — varchar(20) — NOT NULL — 이름
- Field3 (lastName) — varchar(20) — NOT NULL — 성
- Field (profileUrl) — text — 프로필사진 URL
- createdAt — TIMESTAMP — NOT NULL — 생성일시
- updatedAt — TIMESTAMP — NOT NULL — 수정일시
- status (deletedAt) — TIMESTAMP — 삭제일시