좌우지간

테이블 (4)

Untitled (post)

  • Key (postIndex) — serial — 기본 키 — NOT NULL
  • userIndex — serial — 외래 키 → account.userIndex — NOT NULL
  • Field (postCategory) — integer
  • Field2 (postTitle) — varchar(100)
  • Field3 (postDate) — date
  • Field4 (postPremium) — boolean
  • Field (postContent) — varchar(2000)
  • Field (postViews) — int

Untitled (comment)

  • Key (commentIndex) — serial — 기본 키 — NOT NULL
  • userIndex — serial — 외래 키 → account.userIndex — NOT NULL
  • Key (postIndex) — serial — 외래 키 → Untitled.Key — NOT NULL
  • Field (commentDate) — date
  • Field2 (commentContent) — varchar(2000)

Untitled (like)

  • Key (likeIndex) — serial — 기본 키 — NOT NULL
  • Key (postIndex) — serial — 외래 키 → Untitled.Key — NOT NULL
  • userIndex — serial — 외래 키 → Untitled.userIndex — NOT NULL

account

  • userIndex — serial — 기본 키 — NOT NULL
  • Field (userId) — varchar(20)
  • Field2 (userEmail) — varchar(100)
  • Field3 (userNickname) — varchar(20)
  • Field4 (userPw) — varchar(20)
  • Field (userName) — varchar(20)