TimeVenture

Tables (6)

CHATTING

  • Key — Primary key — NOT NULL

COMMENT

  • CNUM (COMMENT_NUMBER) — NUMBER — Primary key — NOT NULL
  • PNUM (PART_NUM) — NUMBER — Foreign key → PART.PNUM — NOT NULL
  • MNAME (MEMBER_NAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMAIL — NOT NULL
  • CCONTENT (COMMENT_CONTENT) — VARCAHR2(1000) — NOT NULL
  • CIMGONAME (COMMENT_IMGONAME) — VARCAHR2(255)
  • CIMGSNAME (COMMENT_IMGSNAME) — VARCAHR2(255)
  • CPOSTDATE (COMMENT_POSTDATE) — DATE — NOT NULL
  • CEDITDATE (COMMENT_EDITDATE) — DATE

MEMBER

  • MEMAIL (MEMBER_EMAIL) — VARCHAR2(50) — Primary key — NOT NULL
  • MLOGIN (MEMBER_LOGINOPTION) — NUMBER(2) — NOT NULL
  • MID (MEMBER_ID) — VARCHAAR2(30) — NOT NULL
  • MPWD (MEMBER_PWD) — VARCHAR2(50) — NOT NULL
  • IMGONAME (MEMBER_IMGONAME) — VARCHAR2(255)
  • IMGSNAME (MEMBER_IMGSNAME) — VARCHAR2(255)
  • MROLE (MEMBER_ROLE) — VARCHAR2(50) — NOT NULL
  • MNAME (MEMBER_NAME) — VARCHAR2(50) — NOT NULL

PART

  • PNUM (PART_NUM) — NUMBER — Primary key — NOT NULL
  • SNUM (SECTION_NUMBER) — NUMBER — Foreign key → SECTION.SNUM — NOT NULL
  • MNAME (MEMBER_NAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMAIL — NOT NULL
  • PTITLE (PART_TITLE) — VARCHAR2(255) — NOT NULL
  • PCONTENT (PART_CONTENT) — VARCHAR2(1000) — NOT NULL
  • PPOSTDATE (PART_POSTDATE) — DATE — NOT NULL
  • PEDITDATE (PART_EDITDATE) — DATE
  • PFIREDATE (PART_FIREDATE) — DATE
  • PSTATUS (PART_STATUS) — VARCHAR2(30)

PROJECT

  • TNUM (TAG_NUM) — NUMBNER(5) — Primary key — NOT NULL
  • MNAME (MEMBER_NAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMAIL — NOT NULL
  • TNAME (TAG_NAME) — VARCHAR2(100) — NOT NULL
  • TPOSTDATE (TAG_POSTDATE) — DATE — NOT NULL

SECTION

  • SNUM (SECTION_NUMBER) — NUMBER — Primary key — NOT NULL
  • TNUM (TAG_NUM) — NUMBNER(5) — Foreign key → PROJECT.TNUM — NOT NULL
  • MNAME (MEMBER_NAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMAIL — NOT NULL
  • SNAME (SECTION_NAME) — VARCHAR2(255) — NOT NULL
  • SPOSTDATE (SECTION_POSTDATE) — DATE — NOT NULL