editor
Tables (4)
approve
- 회원번호 (memberSeq) — NUMBER — Foreign key → member.회원번호 — NOT NULL
- 글번호 (postSeq) — NUMBER
- 승인분류 (approveCategory) — VARCHAR2
- 승인제목 (approveTitle) — VARCHAR2
- 승인내용 (approveContents) — VARCHAR2
- 승인날짜 (approveDate) — DATE
individual
- 글번호 (postSeq) — NUMBER — Primary key — NOT NULL
- 회원번호 (memberSeq) — NUMBER — Foreign key → member.회원번호 — NOT NULL
- 개인분류 (individualCategory) — VARCHAR2
- 승인제목 (approveTitle) — VARCHAR2
- 승인내용 (approveContents) — VARCHAR2
- 승인날짜 (approveDate) — DATE
member
- 회원번호 (memberSeq) — NUMBER — Primary key — NOT NULL
- 회원아이디 (memberId) — VARCHAR2
- 회원비밀번호 (memberPw) — VARCHAR2
- 회원이름 (memberName) — VARCHAR2
- 회원SNS (memberSns) — VARCHAR2
- 회원등급 (memberGrade) — VARCHAR2
post
- 회원번호 (memberSeq) — NUMBER — Foreign key → member.회원번호 — NOT NULL
- 글번호 (postSeq) — NUMBER
- 승인분류 (approveCategory) — VARCHAR2
- 승인제목 (approveTitle) — VARCHAR2
- 승인내용 (approveContents) — VARCHAR2
- 승인날짜 (approveDate) — DATE