Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[INGREDIENTE](
- [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
- [NOME] [varchar](20) NOT NULL,
- [CALORIA] [decimal](18, 2) NOT NULL
- )
- CREATE TABLE [dbo].[RECEITA](
- [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
- [TITULO] [varchar](20) NOT NULL,
- [DESCRICAO] [varchar](20) NOT NULL,
- [TEMPO] time NOT NULL
- )
- CREATE TABLE [dbo].[INGREDIENTE_RECEITA](
- [ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
- [ID_INGREDIENTE] [int] NOT NULL FOREIGN KEY REFERENCES INGREDIENTE,
- [ID_RECEITA] [int] NOT NULL FOREIGN KEY REFERENCES RECEITA
- )
- ------------------------------------------------------------------
- --Preencher dados
- INSERT INTO INGREDIENTE VALUES ('Açucar', 200)
- INSERT INTO INGREDIENTE VALUES ('Farinha', 250)
- INSERT INTO INGREDIENTE VALUES ('Ovo', 200)
- INSERT INTO INGREDIENTE VALUES ('Cenoura', 100)
- INSERT INTO RECEITA VALUES ('Bolo de Cenoura', 'blablablá', '00:25:00.000')
- INSERT INTO INGREDIENTE_RECEITA VALUES (1, 1)
- INSERT INTO INGREDIENTE_RECEITA VALUES (2, 1)
- INSERT INTO INGREDIENTE_RECEITA VALUES (3, 1)
- INSERT INTO INGREDIENTE_RECEITA VALUES (4, 1)
Add Comment
Please, Sign In to add comment