Ana içeriğe geç

Members

Akademi Eğitim Platformu Members Dökümanı​

CREATE TABLE `academy_members` (
    `memberId` INT NOT NULL AUTO_INCREMENT,
    `academyId` INT NOT NULL,
    `userId` INT NOT NULL,
    `role` VARCHAR(50), -- 'admin', 'instructor', 'assistant', 'student'
    `membershipType` VARCHAR(50), -- 'monthly', 'annual', 'corporate', 'trial'
    `joinedAt` DATETIME,
    `expiresAt` DATETIME,
    `status` VARCHAR(50), -- 'active', 'expired', 'suspended', 'pending'
    `inviteId` INT,
    `notes` TEXT,
    `createdAt` DATETIME,
    `createdBy` INT,
    `updatedAt` DATETIME,
    `updatedBy` INT,
    CONSTRAINT `pk_academy_members` PRIMARY KEY (`memberId`),
    CONSTRAINT `fk_members_academy` FOREIGN KEY (`academyId`) REFERENCES `academy`(`academyId`),
    CONSTRAINT `fk_members_user` FOREIGN KEY (`userId`) REFERENCES `mobildev360.user`(`userId`),
    CONSTRAINT `uq_members_academy_user` UNIQUE KEY (`academyId`, `userId`)
);