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