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