USE QL_HighlandsCoffee;
GO

CREATE TABLE CHINHANH (
    MaCN CHAR(5) PRIMARY KEY,
    TenCN NVARCHAR(50) NOT NULL,
    DiaChi NVARCHAR(100) NOT NULL,
    SDT VARCHAR(15) UNIQUE CHECK (LEN(SDT) >= 10),
    NgayMo DATE DEFAULT GETDATE()
);
GO

CREATE TABLE SANPHAM (
    MaSP CHAR(5) PRIMARY KEY,
    TenSP NVARCHAR(50) NOT NULL,
    DonGia DECIMAL(10, 2) CHECK (DonGia > 0),
    LoaiSP NVARCHAR(30) NULL
);
GO