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)