tabel

Table Brand --> kl ditampilan itu Merk

CREATE TABLE BRAND (
ID int IDENTITY(1,1) NOT NULL,
S_NAME varchar(15) NOT NULL,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;
contoh Insert
INSERT INTO [pims].[dbo].[BRAND]
([S_NAME]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
('Nusantara'
,Null
,null
,GETDATE()
,1)
GO


Table Destination
CREATE TABLE Destination(
ID int IDENTITY(1,1) NOT NULL,
S_NAME varchar(15) NOT NULL,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

contoh Insert
INSERT INTO [pims].[dbo].[BRAND]
([S_NAME]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
('Afrika'
,Null
,null
,GETDATE()
,1)
GO

Table Etiket --> kl ditampilan ini yang Brand
CREATE TABLE ETIKET (
ID int IDENTITY(1,1) NOT NULL,
BRAND_ID int NOT NULL,
KODE_BRAND varchar(20) NOT NULL,
TAR binary null,
NIKOTIN binary null,
CO binary null,
S_NOTE varchar(30) NULL,
USER_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

INSERT INTO [pims].[dbo].[ETIKET]
([BRAND_ID]
,[KODE_BRAND]
,[TAR]
,[NIKOTIN]
,[CO]
,[S_NOTE]
,[USER_ID]
,[DT_MOD]
,[I_ST_DOC])
VALUES
(1
,'12 KNM'
,'0'
,'0'
,'0'
,Null
,Null
,getDate()
,1)


Table Order
CREATE TABLE ORDERS(
ORDER_ID varchar(15) NOT NULL,
ORDER_DATE varchar(10) NOT NULL,
S_NOTE varchar(30) NULL,
USER_PIMS_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL
)
;

CREATE TABLE ORDER_DETAIL (
ORDER_DETAIL_ID varchar(10) NOT NULL,
ORDER_ID varchar(15) NOT NULL,
BRAND_ID int NOT NULL,
ETIKET_ID int NOT NULL,
DESTINATION_ID int NOT NULL,
KODE_PRODUKSI_ID int NOT NULL,
QUANTITY float NOT NULL,
DELIVER_DATE datetime NOT NULL,
USER_PIMS_ID varchar(15) NOT NULL,
DT_MOD datetime NOT NULL,
I_ST_DOC int NOT NULL,
S_NOTE varchar(30) NULL
)
;