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)