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)