좌우지간
테이블 (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)