bwa GO

-Users
* id : int
* name : varchar
* occupation : varchar
* email : varchar
* password_hash : varchar
* avatar_file_name : varchar
* role : varchar
* token : varchar
* created_at : datetime
* updated_at : datetime

-Campaigns
* id : int pk
* user_id : int -->dari id user
* name : varchar
* short_description : varchar
* description : text
* goal_amount : int
* current_amount : int
* perks : text
* backer_count : int
* slug : varchar
* created_at : datetime
* updated_at : datetime

CREATE TABLE bwa_go.Campaigns (
	id INT auto_increment NOT NULL PRIMARY KEY,
	campaign_id INT NULL,
	user_id INT NULL,
	amount INT NULL,
	status varchar(100) NULL,
	code varchar(100) NULL,
	created_at DATETIME NULL,
	updated_at DATETIME NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;



-Campaign Images
* id : int
* campaign_id int
* file_name : varchar
* is_primary : boolean (tinyint) -->gambar utama
* created_at : datetime
* updated_at : datetime

CREATE TABLE bwa_go.campaign_images (
	id INT auto_increment NOT NULL PRIMARY KEY,
	campaign_id INT NULL,
	file_name varchar(100) NULL,
	is_primary TINYINT NULL,
	created_at DATETIME NULL,
	updated_at DATETIME NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

-Transaction
* id : int NOT NULL PRIMARY KEY AUTO_INCREMENT
* campaign_id : int
* user_id : int
* amount : int
* status : varchar
* code : varchar
* created_at : datetime
* updated_at : datetime

CREATE TABLE bwa_go.`transaction` (
	id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	Column1 INT NULL,
	user_id INT NULL,
	amount INT NULL,
	status varchar(100) NULL,
	code varchar(100) NULL,
	created_at DATETIME NULL,
	updated_at DATETIME NULL
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci;

Cek relasi di https://prntscr.com/10kiea7