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
  • EMAIL
  • CAUTION (Field)