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