schema initial design final BOOOYA