jum5
Tables (13)
BOARD (Untitled)
- SEQ — number — Primary key — NOT NULL
- TITLE — varchar2(50)
- CONTENT — varchar2(2000)
- NAME — varchar2(20)
- REG_DATE — date
- READCOUNT — number
FILEUPLOAD (Untitled2)
- FILENUM — number — Primary key — NOT NULL
- SEQ — number
- ORG_FILE_NAME — varchar2(260)
- STORED_FILE_NAME — varchar2(36)
- FILE_SIZE — number
- REGDATE — date
- DEL_GB — varchar2(1)
MANAGER (Untitled3)
- NUM — number — Primary key — NOT NULL
- ID — varchar2(30)
- PASSWORD — varchar2(30)
- PHONENUM — varchar2(30)
- Field
MEMBER (Untitled4)
- NUM — number — Primary key — NOT NULL
- ID — varchar2(30)
- PASSWORD — varchar2(100)
- NAME — varchar2(20)
- NICKNAME — varchar2(30)
- BIRTH — varchar2(30)
- GENDER — varchar2(10)
- MEMBERSHIP — number
- DATECOUNT — number
- JOIN_DATE — date
- SESSION_STATE — number
- EMAIL — varchar2(30)
- PRICE — number
- FIRSTPAYMENT — number
- ADMIN — varchar2(20)
MEMBERSHIPKIND (Untitled5)
- MEMBERSHIPTYPE — number — Primary key — NOT NULL
- PAYMENT — number
- DATECOUNT — number
METCH (Untitled6)
- IDX — number — Primary key — NOT NULL
- SENDER_ID — varchar2(30)
- RECEIVER_ID — varchar2(30)
- METCH_STATUS — number
NOTICE (Untitled7)
- BNO — number — Primary key — NOT NULL
- NAME — varchar2(20)
- TITLE — varchar2(100)
- CONTENT — varchar2(2000)
- READCOUNT — number
- REGDATE — date
NOTICEFILE (Untitled8)
- FILE_NO — number — Primary key — NOT NULL
- BNO — number
- ORG_FILE_NAME — varchar2(260)
- STORED_FILE_NAME — varchar2(36)
- FILE_SIZE — number
- REGDATE — date
- DEL_GB — varchar2(1)
PAYSTATE (Untitled9)
- NUM (NUM2) — number — Foreign key → MEMBER.NUM — NOT NULL
- ID — varchar2(30)
- PAY_PRICE — number
- PAY_DATE — date
- PAY_STATE — varchar2(30)
PROFILE (Untitled10)
- NUM (NUM2) — number — Foreign key → MEMBER.NUM — NOT NULL
- NICKNAME — varchar2(30)
- HEIGHT — number
- WEIGHT — number
- CHARACTER — varchar2(100)
- HOBBY — varchar2(50)
- BLOODTYPE — varchar2(10)
- JOB — varchar2(100)
- SALARY — number
- ADDRESS — varchar2(100)
- IDEAL_TYPE — varchar2(100)
- IMAGEFILE — varchar2(100)
- AGE — number
QUESTION (Untitled11)
- NUM (NUM2) — number — Foreign key → MEMBER.NUM — NOT NULL
- ID — varchar2(30)
- TITLE — varchar2(100)
- CONTENT — varchar2(100)
- WDATE — date
- COUNT — number
- STATE — varchar2(20)
QUESTIONANSWER (Untitled12)
- NUM (NUM22) — number — Foreign key → QUESTION.NUM — NOT NULL
- QA_NUM — number
- ANSWER — varchar2(1000)
- ANSWER_DATE — date
RCOMMENT (Untitled13)
- SEQ (SEQ2) — number — Foreign key → BOARD.SEQ — NOT NULL
- RSEQ — number
- CONTENT — varchar2(1000)
- WRITER — varchar2(50)
- REGDATE — date