bucky

Tables (8)

bucketList (Untitled)

  • bucketId (Key) — PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
  • title (Field)
  • isVisible (Field3) — DEFAULT 0
  • startDate (Field4)
  • endDate (Field5) — endDate > startDate
  • createdDate (Field6) — DEFAULT CURRENT_DATE
  • achievedDate (Field7)
  • profilePict (Field8)
  • achievePict (Field9)
  • email (Key2) — CHECK(email LIKE '%@%.____') — Foreign key → users.email — NOT NULL
  • bucketTags (Field10) — delimited by ,

bucketListHeart (Untitled8)

  • email (Key) — PRIMARY KEY CHECK(email LIKE '%@%.____') — Foreign key → users.email — NOT NULL
  • bucketId (Key2) — PRIMARY KEY AUTO_INCREMENT — Foreign key → bucketList.bucketId — NOT NULL

detailPlan (Untitled5)

  • orderNumb (Key) — PRIMARY KEY NOT NULL — Primary key — NOT NULL
  • bucketId (Key2) — PRIMARY KEY AUTO_INCREMENT — Foreign key → bucketList.bucketId — NOT NULL
  • content (Field)
  • planDate (Field2) — NOT NULL
  • achieved (Field3) — DEFAULT 0

review (Untitled6)

  • bucketId (Key) — PRIMARY KEY AUTO_INCREMENT — Foreign key → bucketList.bucketId — NOT NULL
  • writtenDate (Field) — DEFAULT CURRENT_TIMESTAMP
  • reviewPaths (Field2) — paths delimited by ,

systemTags (Untitled3)

  • tag (Key) — PRIMARY KEY — Primary key — NOT NULL

userInterestTags (Untitled4)

  • email (Key2) — PRIMARY KEY CHECK(email LIKE '%@%.____') — Foreign key → users.email — NOT NULL
  • tag (Key) — PRIMARY KEY — Foreign key → systemTags.tag — NOT NULL

users (Untitled2)

  • email (Key) — PRIMARY KEY CHECK(email LIKE '%@%.____') — Primary key — NOT NULL
  • password (Field) — NOT NULL
  • nickname (Field2) — NOT NULL UNIQUE
  • profilePicturePath (Field3)

verifyRequest (Untitled7)

  • requestDate (Key) — PRIMARY KEY DEFAULT CURRENT_TIMESTAMP — Primary key — NOT NULL
  • bucketId (Key2) — PRIMARY KEY AUTO_INCREMENT — Foreign key → bucketList.bucketId — NOT NULL
  • content (Field)
  • state (Field2) — DEFAULT 0
  • verifyRequestPicts (Field3)