Tabela Empresa SQL SERVER

DB Design >>>> File > Export > SQL script



CREATE DATABASE EMPRESA
	GO

	      USE Empresa

         CREATE TABLE IEmpresa(
         IDEMPRESA INT PRIMARY KEY NOT NULL,
         RAZAOSOCIAL VARCHAR(50) NOT NULL,
		 CNPJ VARCHAR (50) NULL,
         ENDERECO VARCHAR(50) NOT NULL,
         BAIRRO VARCHAR (50) NOT NULL,
         CIDADE VARCHAR(50) NOT NULL,
         UF CHAR (2) NOT NULL,
		 TELEFONE VARCHAR (50) NOT NULL,
         )
		 GO

		  SELECT * FROM IEmpresa

         INSERT INTO IEmpresa
         VALUES

         (1,'Positivo','31.525.578/0001-95','RUA Anne Frank,0000','Hauer','CURITIBA','PR','3030-2020'),
         (2,'Wizard','31.525.578/0001-96','RUA Marechal Floriano,0000','Boqueirão','CURITIBA','PR','1010-2040'),
         (3,'Balaroti','31.525.578/0001-97','RUA Anne frank,0001','Hauer','CURITIBA','PR','3030-4040')


		 /*------------------------------------------------------------------------------------------------------------*/


		 CREATE TABLE Cinema(

		 IDCINEMA INT PRIMARY KEY NOT NULL,
		 IDEMPRESA INT NOT NULL,
		 CNPJ VARCHAR (50) NULL,
		 NOMEFANTASIA VARCHAR (50) NULL,
		 ENDERECO VARCHAR (50) NULL,
		 BAIRRO VARCHAR (50) NULL,
		 CIDADE VARCHAR(50) NOT NULL,
         UF CHAR (2) NOT NULL,
		 TELEFONE VARCHAR (50) NOT NULL,
		 CAPACIDADELOTACAO INT NOT NULL,
		 )
		 GO

		 SELECT * FROM Cinema

		 INSERT INTO Cinema
		 VALUES

		 (1,2,'31.525.578/0001-00','Cinemar','Rua José Silva,23','Hauer','CURITIBA','PR','3070-2020',300),
         (2,3,'31.525.578/0001-01','Cinemak','Rua Carlos José,10','Boqueirão','CURITIBA','PR','1080-2040',250),
         (3,1,'31.525.578/0001-03','Cinemat','Rua Manoel Ribas,13','Hauer','CURITIBA','PR','3030-4840',180)


 		 /*------------------------------------------------------------------------------------------------------------*/


        CREATE TABLE Sessao(
		IDSESSAO INT PRIMARY KEY NOT NULL,
		IDCINEMA INT NOT NULL,
		HORARIO TIME NOT NULL,
		VALORINGRESSO VARCHAR (50) NOT NULL,
		)
		GO

		SELECT * FROM Sessao

		INSERT INTO Sessao
		VALUES

		 (1,2,'10:15','R$: 10,00'),
         (2,3,'11:15','R$: 10,00'),
         (3,1,'15:45','R$: 10,00')

		 /*---------------------------------------------------------------------------------------*/


		 CREATE TABLE Filme(
		 IDFILME INT PRIMARY KEY NOT NULL,
		 TITULO VARCHAR (50) NOT NULL,
		 GENERO VARCHAR (50) NOT  NULL,
		 DURACAO VARCHAR (50) NOT NULL,
		 CLASSIFICACAOINDICATIVA VARCHAR (50) NOT NULL,
		 PAISORIGEM VARCHAR (50) NOT NULL,
		 INFORMACAOATORES VARCHAR (50) NOT NULL,
		 IDDIRETOR INT NOT NULL,
		 )
		 GO

		 SELECT * FROM Filme

		 INSERT INTO Filme
		 VALUES

   		 (5,'A casa de vidro','Suspense','2:30h','16 anos','EUA','aaaaaaaaaaaa',22),
   		 (7,'A casa de cera','Suspense','2:40h','16 anos','EUA','aaaaaaaaaaaa',23),
      	 (9,'O chamado','Suspense','2:50h','16 anos','UK','aaaaaaaaaaaa',21)

		 /*-----------------------------------------------------------------------------------------------*/

		 CREATE TABLE AtorDiretor(
			NOME VARCHAR (50) NOT NULL,
			ID INT NOT NULL,
			NACIONALIDADE VARCHAR (50) NOT NULL,
			IDADE INT NOT NULL,
			CELULAR VARCHAR (50) NOT NULL,
			)

			SELECT * FROM AtorDiretor

			INSERT INTO AtorDiretor
			VALUES
			('Carlos',55,'Brasileiro','38','8800-8900'),
			('Pedro',34,'Brasileiro','45','8801-8970'),
			('Jose',32,'Brasileiro','29','8802-8980')