logged.me

Tables (11)

Badge (뱃지)

  • id (뱃지 id) — INT — Primary key — NOT NULL
  • image (뱃지 사진) — IMAGE
  • content (뱃지 설명) — CHAR
  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • id (유저 id2) — INT — Foreign key → User.id — NOT NULL

Comment (댓글)

  • id (댓글 id) — INT — Primary key — NOT NULL
  • content (내용) — CHAR
  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • id (게시물id) — INT — Foreign key → Post.id — NOT NULL

CommonPost (일반 게시물)

  • id (게시물id) — INT — Foreign key → Post.id — NOT NULL
  • id (유저 id) — INT — Foreign key → User.id — NOT NULL

CommonUser (일반 계정)

  • id (유저 id) — INT — Foreign key → User.id — NOT NULL

Company (기업 계정)

  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • name (회사 이름) — CHAR

CompanyPost (기업 게시물)

  • id (게시물id) — INT — Foreign key → Post.id — NOT NULL

Follow (팔로우)

  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • id (유저 id2) — INT — Foreign key → User.id — NOT NULL

Like (좋아요)

  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • id (게시물id) — INT — Foreign key → Post.id — NOT NULL

Post (게시물)

  • id (게시물id) — INT — Primary key — NOT NULL
  • image (사진) — IMAGE
  • content (내용) — CHAR
  • id (유저 id) — INT — Foreign key → User.id — NOT NULL

Reply (답글)

  • id (댓글 id) — INT — Primary key — NOT NULL
  • content (내용) — CHAR
  • id (유저 id) — INT — Foreign key → User.id — NOT NULL
  • id (댓글 id2) — INT — Foreign key → Comment.id — NOT NULL

User (사용자)

  • id (유저 id) — INT — Primary key — NOT NULL
  • email (이메일) — EMAIL
  • password (비밀번호) — PASSWORD
  • username (유저 이름) — CHAR
  • type (유저 타입) — CHAR
  • image (프로필 사진) — IMAGE