TeamProject
Tables (20)
APPLICANT
- APPSEQ (Key) — Primary key — NOT NULL
- RECRUITSEQ (Key2) — Foreign key → RECRUIT.RECRUITSEQ — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- INDATE (Field2)
- COMMENT (Field)
CAMSTUDY
- CAMSEQ (Key) — Primary key — NOT NULL
- MEMBERSEQ (Key2) — Foreign key → STUDYMEMBER.MEMBERSEQ — NOT NULL
- INDATE (Field) — DATE
- PICTURE (Field2)
- STARTTIME (Field3)
CAMTIME
- TIMESEQ (Key) — Primary key — NOT NULL
- CAMSEQ (Key2) — Foreign key → CAMSTUDY.CAMSEQ — NOT NULL
- TOTALTIME (Field)
DDAY
- DDAYSEQ (Key) — Primary key — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- STADATE (Field) — DATE
- ENDDATE (Field2) — DATE
- CONTENT (Field3)
FILE
- FILESEQ (Key) — Primary key — NOT NULL
- BOARDSEQ — Foreign key → STUDYBOARD.BOARDSEQ — NOT NULL
- CHATSEQ (Key2) — Foreign key → STUDYCHAT.CHATSEQ — NOT NULL
- OR_NAME (Field)
- NAME (Field2)
OXQUIZ
- QUIZSEQ — Primary key — NOT NULL
- TESTSEQ (Key) — Foreign key → TEST.TESTSEQ — NOT NULL
- QUSETION (Field)
- ANSWER (Field2)
- Field3
RECRUIT
- RECRUITSEQ (Key) — Primary key — NOT NULL
- STUDYSEQ — Foreign key → STUDY.STUDYSEQ — NOT NULL
- RESTART (Field) — DATE
- REEND (Field2) — DATE
- COMMENT (Field3)
- REQUIRE (Field4)
- EMAILRE (Field5)
- NAMERE (Field6)
- TELRE (Field7)
- TYPE (Field8)
SCORE
- SCORESEQ (Key) — Primary key — NOT NULL
- QUIZSEQ — Foreign key → OXQUIZ.QUIZSEQ — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- SQUIZSEQ — Foreign key → SUMQUIZ.SQUIZSEQ — NOT NULL
- RESULT (Field)
STUDY
- STUDYSEQ — Primary key — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- SNAME
- STADATE — DATE
- ENDDATE — DATE
- TYPE (STYPE)
- SMNUM
- SDAY
- SSTATIME (SSTATTIME)
- SENDTIME
STUDYBOARD
- BOARDSEQ — Primary key — NOT NULL
- STUDYSEQ — Foreign key → STUDY.STUDYSEQ — NOT NULL
- ID — Foreign key → STUDYMEMBER.ID — NOT NULL
- BTYPE (Field2)
- TITLE (Field4)
- CONTENT (Field5)
- INDATE (Field6) — DATE
STUDYCHAT
- CHATSEQ (Key) — Primary key — NOT NULL
- MEMBERSEQ (Key2) — Foreign key → STUDYMEMBER.MEMBERSEQ — NOT NULL
- CONTENT (Field2)
- INDATE (Field3) — DATE
STUDYCOMMENT
- COMMENTSEQ (Key) — Primary key — NOT NULL
- ID — Foreign key → STUDYMEMBER.ID — NOT NULL
- BOARDSEQ — Foreign key → STUDYBOARD.BOARDSEQ — NOT NULL
- CONTENT (Field3)
- INDATE (Field4)
STUDYMEMBER
- MEMBERSEQ (Key) — Primary key — NOT NULL
- STUDYSEQ — Foreign key → STUDY.STUDYSEQ — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- INDATE (Field2) — DATE
SUMMERIZE
- SUMSEQ — Primary key — NOT NULL
- TESTSEQ (Key) — Foreign key → TEST.TESTSEQ — NOT NULL
- OR_NAME (Field)
- NAME (Field2)
SUMQUIZ
- SQUIZSEQ — Primary key — NOT NULL
- SUMSEQ — Foreign key → SUMMERIZE.SUMSEQ — NOT NULL
- QUESTION (Field)
- ANSWER (Field2)
TEST
- TESTSEQ (Key) — Primary key — NOT NULL
- BOARDSEQ — Foreign key → STUDYBOARD.BOARDSEQ — NOT NULL
TODOLIST
- LISTSEQ (Key) — Primary key — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- CONTENT (Field)
- SEQUENCE (Field2)
TREE
- TREESEQ (Key) — Primary key — NOT NULL
- POINTSEQ (Key2) — Foreign key → TREEPOINT.POINTSEQ — NOT NULL
- STATUS (Field)
- TYPE (Field2)
TREEPOINT
- POINTSEQ (Key) — Primary key — NOT NULL
- ID — Foreign key → USER.ID — NOT NULL
- TREEPOINT (Field)
USER
- ID — Primary key — NOT NULL
- TEL — UNIQUE KEY
- PW
- TYPE
- NAME
- NICK
- PICTURE
- CAUTION (Field)