teamProject

Tables (4)

TBL_MENTI (Untitled2)

  • Key — Primary key — NOT NULL
  • userNumber — NUMBER — Foreign key → TBL_USER.userNumber — NOT NULL
  • teamNumber — Number — Foreign key → TBL_USER.teamNumber — NOT NULL

TBL_MENTO (Untitled3)

  • Key — Primary key — NOT NULL
  • userNumber — NUMBER — Foreign key → TBL_USER.userNumber — NOT NULL
  • teamNumber — Number — Foreign key → TBL_USER.teamNumber — NOT NULL

TBL_TEAM (Untitled4)

  • teamNumber — Number — Primary key — NOT NULL
  • teamName — VARCHAR2(1000)
  • userNumber — Number

TBL_USER (Untitled)

  • userNumber — NUMBER — Primary key — NOT NULL
  • teamNumber — Number — Foreign key → TBL_TEAM.teamNumber — NOT NULL
  • userId — VARCHAR2(1000)
  • userPw — VARCHAR2(1000)
  • userPhoneNumber — VARCHAR2(1000)
  • userBirth — VARCHAR2(1000)
  • userGender — CHAR(1)
  • userLocation — VARCHAR2(1000)