player_table_query - MukeshKumar101/IPL_Auction GitHub Wiki

CREATE TABLE player (

id BINARY(16) NOT NULL, name VARCHAR(50) NOT NULL, dob DATE NOT NULL, role ENUM('batsman','bowling','all-rounder','wicket-keeper') NOT NULL, batting_style ENUM('right-handed','left-handed') NOT NULL, bowling_style ENUM('right-arm-fast','right-arm-fast-medium','left-arm-fast','left-arm-fast-medium','right-arm-off-break','right-arm-leg-break','left-arm-off-break','left-arm-leg-break','left-arm-orthodox','left-arm-chinaman','right-arm-orthodox','right-arm-chinaman') NOT NULL, base_price BIGINT(8) NOT NULL, origin VARCHAR(50) NOT NULL, capped TINYINT(2) NOT NULL, image_url VARCHAR(50) NOT NULL, status ENUM('sold','unsold','onlive','idle') NOT NULL, active TINYINT(2) NOT NULL DEFAULT '1', created_by BINARY(16) NULL DEFAULT NULL, updated_by BINARY(16) NULL DEFAULT NULL, created_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', updated_on DATETIME NULL DEFAULT 'CURRENT_TIMESTAMP', PRIMARY KEY (`id) USING BTREE`

);