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