jobis-project
Tables (4)
Comment (댓글)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — VARCHAR(150)
- Key (id2) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (id3) — BIGINT — Foreign key → Post.Key — NOT NULL
Follower (팔로워)
- Key (id) — Primary key — NOT NULL
- Field (username) — VARCHAR(20)
- Key (id2) — BIGINT — Foreign key → User.Key — NOT NULL
Post (게시글)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (title) — VARCHAR(40)
- Field (content) — VARCHAR(500) — NOT NULL
- Field (like) — INT(4)
- Key (id2) — BIGINT — Foreign key → User.Key — NOT NULL
User (유저)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (username) — VARCHAR(20)
- Field (password) — VARCHAR(25)