202053083

CREATE DATABASE db_202053083

USE db_202053083

CREATE TABLE [dbo].[barang](
    [id] [INT] IDENTITY PRIMARY KEY NOT NULL,
    [nama] [VARCHAR](MAX) NULL,
    [jenis] [VARCHAR](MAX) NULL,
    [nama_supplier] [VARCHAR](MAX) NULL,
    [modal] [INT] NULL,
    [harga] [INT] NULL,
    [jumlah] [INT] NULL,
    [sisa] [INT] NULL
)

CREATE TABLE [dbo].[penjualan](
    [id] [INT] IDENTITY PRIMARY KEY NOT NULL,
    [tanggal] [DATE] NULL,
    [nama] [VARCHAR](MAX)  NULL,
    [jumlah] [INT] NULL,
    [harga] [INT]  NULL,
    [total_harga] [INT] NULL,
    [laba] [INT] NULL
)

CREATE TABLE [dbo].[supplier](
    [id] [INT] NOT NULL IDENTITY PRIMARY KEY,
    [nama_supplier] [VARCHAR](MAX) NULL,
    [alamat] [VARCHAR](MAX) NULL,
    [telepon] [VARCHAR](15) NULL
)

CREATE TABLE [dbo].[USER](
    [email] [VARCHAR](50) NULL,
    [password] [VARCHAR](20) NULL,
    [nama] [VARCHAR](50) NULL,
    [STATUS] [VARCHAR](10) NULL
)
-- contoh perintah input
INSERT INTO barang VALUES
    ('Flashdisk Sandisk 32GB Cruzer Blade', 'Media Penyimpanan', 'PT. Datascript', '72000', '90000', '89', '100'),
    ('Flashdisk Sandisk 16GB Cruzer Blade', 'Media Penyimpanan', 'PT. Datascript', '50000', '70000', '134', '150'),
    ('Flashdisk Kioxia 16GB', 'Media Penyimpanan', 'PT. Astrindo', '49000', '70000', '45', '90'),
    ('Flashdisk Kioxia 64GB', 'Media Penyimpanan', 'PT. Astrindo', '96000', '140000', '38', '40'),
    ('SSD Seaget Barracuda 512GB', 'Media Penyimpanan', 'PT. Seaget Memory', '1280000', '1450000', '22', '30');