Bonjour,
Mon employeur m'a chargé de développer une gestion commerciale (facturation, gestion de stock, multi-depots, caisse..). Je ne sais pas avec quoi commencer, je galère avec la DB, je ne sais pas quelle table créer avec quel champ...
J'ai pu crée quelles tables notamment (articles, clients, fournisseurs)
Mais je ne sais pas comment faire pour les tables des factures devis BL BC...
Merci de me donner un coup de main.
Bonne journée
----------------------------table articles---------------------------------
CREATE TABLE ARTICLES (
IDARTICLES INTEGER NOT NULL,
IDFOURNISSUER INTEGER NOT NULL,
IDFAMILLE INTEGER NOT NULL,
IDLOCALISATION INTEGER NOT NULL,
CODE VARCHAR(30) CHARACTER SET WIN1251 COLLATE WIN1251,
DESIGNATION VARCHAR(50) CHARACTER SET WIN1251 COLLATE WIN1251,
PRIX_ACHAT DECIMAL(7, 2),
PRIX_VENTE DECIMAL(7, 2),
REMISABLE OUINON NOT NULL,
BLOQUER OUINON NOT NULL,
QTE_STOCK INTEGER DEFAULT 0,
STOCK_MINI INTEGER DEFAULT 0,
STOCK_MAXI INTEGER DEFAULT 0,
DESCRIPTION LONGTEXT,
IMAGE BLOB,
DTE_ENTREE DATE,
DTE_SORTIE DATE,
DTE_CREAT DATE,
DTE_MODIF DATE,
QTE_CMD INTEGER DEFAULT 0,
CODEBARRE VARCHAR(30) CHARACTER SET WIN1251 COLLATE WIN1251);
CREATE INDEX ARTICLE_CODE ON ARTICLES(CODE);
CREATE INDEX ARTICLE_CODEBARRE ON ARTICLES(CODEBARRE);
CREATE INDEX ARTICLE_FAMILLE ON ARTICLES(IDFAMILLE,CODE);
CREATE INDEX ARTICLE_FOURNISSEUR ON ARTICLES(IDFOURNISSUER,CODE);
CREATE INDEX ARTICLE_LOCALISATION ON ARTICLES(IDLOCALISATION,CODE);
--------------------------------Table clients------------------------------
CREATE TABLE CLIENTS (
IDCLIENT INTEGER NOT NULL,
DATE_CREATION DATE NOT NULL,
NUMERO_CLIENT INTEGER DEFAULT 000000 NOT NULL,
"TYPE" PARTICULIER NOT NULL,
CIVILITE CIVILITE NOT NULL,
NOM VARCHAR(100) CHARACTER SET ISO8859_1 NOT NULL COLLATE ISO8859_1,
PRENOM VARCHAR(100) CHARACTER SET ISO8859_1 NOT NULL COLLATE ISO8859_1,
N_RC VARCHAR(30) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
N_IF VARCHAR(30) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
N_PATENTE VARCHAR(30) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
ADRESSE LONGTEXT,
CODE_POSTAL VARCHAR(20) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
VILLE VARCHAR(100) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
PAYS VARCHAR(100) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
TEL_FIXE VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
TEL_GSM VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
FAX VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ISO8859_1,
EMAIL VARCHAR(100) CHARACTER SET ISO8859_1 DEFAULT 'gestcom@gestcom.ma' COLLATE ISO8859_1,
URL_SITE VARCHAR(100) CHARACTER SET ISO8859_1 DEFAULT 'www.anasoftsys.com' COLLATE ISO8859_1,
REMISE_PARDEFAUT DECIMAL(5, 2) DEFAULT 0.00 NOT NULL,
COMMENTAIRES LONGTEXT DEFAULT null,
POINTS_FIDELITE DECIMAL(15, 2) DEFAULT 0.00 NOT NULL,
DESACTIVE_REMISE_FIDELITE OUINON NOT NULL,
BLOQUER OUINON DEFAULT 'Non' NOT NULL);
------------------------------Table fournisseur---------------------------
CREATE TABLE FOURNISSEUR (
IDFOURNISSEUR INTEGER NOT NULL,
NOM VARCHAR(50) CHARACTER SET WIN1251 COLLATE WIN1251,
TELEPHONE VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251,
ADRESSE VARCHAR(50) CHARACTER SET WIN1251 COLLATE WIN1251,
CODE_POSTAL VARCHAR(5) CHARACTER SET WIN1251 COLLATE WIN1251,
VILLE VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251,
EMAIL VARCHAR(50) CHARACTER SET WIN1251 COLLATE WIN1251,
CONTACT VARCHAR(30) CHARACTER SET WIN1251 COLLATE WIN1251,
DELAI SMALLINT,
CONDITIONS VARCHAR(30) CHARACTER SET WIN1251 COLLATE WIN1251);
CREATE INDEX FOURNISSEUR_NOM ON FOURNISSEUR(NOM);
Partager