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 — 삭제일시