db

테이블 (10)

Admin (Untitled5)

  • NUM — number — 기본 키 — NOT NULL
  • ID — varchar2(20)
  • PASSWORD — varchar2(20)

Membership (Untitled4)

  • NUM — number — 기본 키 — NOT NULL
  • MEMBERSHIP_TYPE — varchar2(20)
  • PAYMENT — number

NOTICE (공지사항) (Untitled6)

  • NUM — number — 기본 키 — NOT NULL
  • WRITER — varchar2(10)
  • TITLE — varchar2(50)
  • CONTENT — varchar2(100)
  • DATE — date

PAYMENT (Untitled7)

  • NUM — number — 기본 키 — NOT NULL
  • ID — varchar2(20)
  • MEMBERSHIP — varchar2(30)
  • PAY_STATE — varchar2(30)

Q&A (Untitled2)

  • NUM — number — 기본 키 — NOT NULL
  • TITLE — varchar2(50)
  • WRITER — varchar2(10)
  • CONTENT — varchar2(100)
  • DATE — date
  • COUNT — number
  • ANSWER STATE — varchar2(10)

Q&A answer (Untitled3)

  • NUM — number — 기본 키 — NOT NULL
  • WRITER — varchar2(20)
  • CONTENT — varchar2(100)

Untitled3 (Postscript (매칭후기))

  • NUM — number — 기본 키 — NOT NULL
  • TITLE — varchar2(50)
  • WRITER — varchar2(20)
  • CONTENT — varchar2(100)
  • IMAGEFILE — varchar2(30)
  • DATE — DATE
  • COUNT — number

Untitled4 (Postscript answer)

  • NUM — number — 기본 키 — NOT NULL
  • WRITER — varchar2(20)
  • CONTENT — varchar2(100)

User (유저) (Untitled)

  • NUM — number — 기본 키 — NOT NULL
  • ID — varchar2(30)
  • PASSWORD — varchar2(30)
  • NAME — varchar2(30)
  • NICKNAME — varchar(30)
  • BIRTH — varchar2(20)
  • SEX — varchar2(10)
  • EMAIL — varchar2(20)
  • PHONE — varchar(30)
  • HEIGHT — number
  • WEIGHT — number
  • SALARTY (SALARY) — number
  • CHARACTER — varchar2(20)
  • HOBBY — varchar2(20)
  • BLOODTYPE — varchar2(10)
  • MEMBERSHIP — varchar2(30)

회원 탈퇴 목록 (Untitled8)

  • NUM — number — 기본 키 — NOT NULL
  • ID — varchar2(20)
  • STATE — varchar2(10)