-- DROP TABLE aipdb.dbo.TB_LINKED_SYSTEM;
CREATE TABLE aipdb.dbo.TB_LINKED_SYSTEM (
	SystemId int IDENTITY(1,1) NOT NULL,
	SystemName varchar(100) COLLATE Korean_Wansung_CI_AS NOT NULL,
	SystemDesc varchar(255) COLLATE Korean_Wansung_CI_AS NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_LINKED_SYSTEM PRIMARY KEY (SystemId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ½Ã½ºÅÛ Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ½Ã½ºÅÛ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'SystemId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ½Ã½ºÅÛ À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'SystemName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ½Ã½ºÅÛ ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'SystemDesc';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SYSTEM', @level2type=N'Column', @level2name=N'UseYn';


-- DROP TABLE aipdb.dbo.TB_LINKED_SERVER;
CREATE TABLE aipdb.dbo.TB_LINKED_SERVER (
	ServerId int IDENTITY(1,1) NOT NULL,
	SystemId int NOT NULL,
	ServerIpAddr varchar(30) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ServerDesc varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_LINKED_SERVER PRIMARY KEY (ServerId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'ServerId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ½Ã½ºÅÛ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'SystemId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö IP Address', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'ServerIpAddr';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'ServerDesc';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_SERVER', @level2type=N'Column', @level2name=N'UseYn';

ALTER TABLE aipdb.dbo.TB_LINKED_SERVER ADD CONSTRAINT FK_LINKED_SERVER_1 FOREIGN KEY (SystemId) REFERENCES aipdb.dbo.TB_LINKED_SYSTEM(SystemId);


-- DROP TABLE aipdb.dbo.TB_LINKED_DESCRYPT_KEY;
CREATE TABLE aipdb.dbo.TB_LINKED_DECRYPT_KEY (
	Id int IDENTITY(1,1) NOT NULL,
	ServerId int NOT NULL,
	DecryptKey varchar(64) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ExpiredAt datetime NOT NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_LINKED_DECRYPTION_KEY PRIMARY KEY (Id)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö º¹È£È­ Å°', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö º¹È£È­ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'Id';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'ServerId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö º¹È£È­ Å°', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'DecryptKey';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸¸·áÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'ExpiredAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_DECRYPT_KEY', @level2type=N'Column', @level2name=N'UseYn';

ALTER TABLE aipdb.dbo.TB_LINKED_DECRYPT_KEY ADD CONSTRAINT FK_LINKED_DECRYPTION_1 FOREIGN KEY (ServerId) REFERENCES aipdb.dbo.TB_LINKED_SERVER(ServerId);


-- DROP TABLE aipdb.dbo.TB_LINKED_API_KEY;
CREATE TABLE aipdb.dbo.TB_LINKED_API_KEY (
	Id int IDENTITY(1,1) NOT NULL,
	ServerId int NOT NULL,
	ApiKey varchar(64) COLLATE Korean_Wansung_CI_AS NOT NULL,
	policyLookupYn bit DEFAULT 0 NOT NULL,
	fileInfoLookupYn bit DEFAULT 0 NOT NULL,
	applyLabelYn bit DEFAULT 0 NOT NULL,
	releaseLabelYn bit DEFAULT 0 NOT NULL,
	encryptionFileYn bit DEFAULT 0 NOT NULL,
	decryptionFileYn bit DEFAULT 0 NOT NULL,
	ExpiredAt datetime NOT NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_LINKED_API_KEY PRIMARY KEY (Id)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö API KEY', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö API KEY ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'Id';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'ServerId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö API KEY', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'ApiKey';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·¹À̺í Á¶È¸ ¹× ÅÛÇø´ Á¶È¸ API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'policyLookupYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ Á¤º¸ Á¶È¸ API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'fileInfoLookupYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·¹À̺í Àû¿ë API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'applyLabelYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·¹À̺í ÇØÁ¦ API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'releaseLabelYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ ¾Ïȣȭ API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'encryptionFileYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ º¹È£È­ API Çã¿ë ¿©ºÎ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'decryptionFileYn';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¸¸·áÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'ExpiredAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_LINKED_API_KEY', @level2type=N'Column', @level2name=N'UseYn';

ALTER TABLE aipdb.dbo.TB_LINKED_API_KEY ADD CONSTRAINT FK_LINKED_API_KEY_1 FOREIGN KEY (ServerId) REFERENCES aipdb.dbo.TB_LINKED_SERVER(ServerId);



-- DROP TABLE aipdb.dbo.TB_AIP_LABEL;
CREATE TABLE aipdb.dbo.TB_AIP_LABEL (
	LabelId int IDENTITY(1,1) NOT NULL,
	LabelGuid varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	LabelName varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	LabelDesc varchar(512) COLLATE Korean_Wansung_CI_AS NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_API_LABEL PRIMARY KEY (LabelId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ·¹À̺í Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ·¹À̺í ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'LabelId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ·¹À̺í GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'LabelGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ·¹À̺í À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'LabelName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ·¹ÀÌºí ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'LabelDesc';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_LABEL', @level2type=N'Column', @level2name=N'UseYn';


-- DROP TABLE aipdb.dbo.TB_AIP_POLICY;
CREATE TABLE aipdb.dbo.TB_AIP_POLICY (
	PolicyId int IDENTITY(1,1) NOT NULL,
	PolicyGuid varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	PolicyName varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	PolicyDesc varchar(512) COLLATE Korean_Wansung_CI_AS NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_API_POLICY PRIMARY KEY (PolicyId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Á¤Ã¥ Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Á¤Ã¥ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'PolicyId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Á¤Ã¥ GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'PolicyGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Á¤Ã¥ À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'PolicyName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Á¤Ã¥ ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'PolicyDesc';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_POLICY', @level2type=N'Column', @level2name=N'UseYn';

-- DROP TABLE aipdb.dbo.TB_AIP_PROTECTION;
CREATE TABLE aipdb.dbo.TB_AIP_PROTECTION (
	ProtectionId int IDENTITY(1,1) NOT NULL,
	ProtectionGuid varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ProtectionName varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ProtectionDesc varchar(512) COLLATE Korean_Wansung_CI_AS NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	DeletedAt datetime NULL,
	UseYn bit DEFAULT 1 NOT NULL,
	CONSTRAINT PK_API_PROTECTION PRIMARY KEY (ProtectionId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP º¸È£Á¤Ã¥ Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP º¸È£Á¤Ã¥ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'ProtectionId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP º¸È£Á¤Ã¥ GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'ProtectionGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP º¸È£Á¤Ã¥ À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'ProtectionName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP º¸È£Á¤Ã¥ ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'ProtectionDesc';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'CreatedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»èÁ¦ÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'DeletedAt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'»ç¿ë¿©ºÎ(1:»ç¿ë,0:»èÁ¦µÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_PROTECTION', @level2type=N'Column', @level2name=N'UseYn';



-- DROP TABLE aipdb.dbo.TB_AIP_SERVER;
CREATE TABLE aipdb.dbo.TB_AIP_SERVER (
	AipServerId int IDENTITY(1,1) NOT NULL,
	AipServerName varchar(255) COLLATE Korean_Wansung_CI_AS NOT NULL,
	IpAddr varchar(30) COLLATE Korean_Wansung_CI_AS NULL,
	Port int NULL default 0,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	CONSTRAINT PK_AIP_SERVER PRIMARY KEY (AipServerId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ¼­¹ö Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ¼­¹ö ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER', @level2type=N'Column', @level2name=N'AipServerId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ¼­¹ö À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER', @level2type=N'Column', @level2name=N'AipServerName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ¼­¹ö IP Address', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER', @level2type=N'Column', @level2name=N'IpAddr';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ¼­¹ö Port', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER', @level2type=N'Column', @level2name=N'Port';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_SERVER', @level2type=N'Column', @level2name=N'CreatedAt';


-- DROP TABLE aipdb.dbo.TB_AIP_CONFIG;
CREATE TABLE aipdb.dbo.TB_AIP_CONFIG (
	Id int IDENTITY(1,1) NOT NULL,
	AipServerId int NOT NULL,
	ConfigKey varchar(1023) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ConfigValue varchar(MAX) COLLATE Korean_Wansung_CI_AS NULL,
	CreatedAt datetime DEFAULT getdate() NOT NULL,
	CONSTRAINT PK_AIP_CONFIG PRIMARY KEY (Id)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ȯ°æ¼³Á¤ Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ȯ°æ¼³Á¤ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG', @level2type=N'Column', @level2name=N'Id';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP Server ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG', @level2type=N'Column', @level2name=N'AipServerId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ȯ°æ¼³Á¤ Key', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG', @level2type=N'Column', @level2name=N'ConfigKey';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP ȯ°æ¼³Á¤ Value', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG', @level2type=N'Column', @level2name=N'ConfigValue';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µî·ÏÀϽÃ(³â¿ùÀϽúÐÃÊ)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_CONFIG', @level2type=N'Column', @level2name=N'CreatedAt';

ALTER TABLE aipdb.dbo.TB_AIP_CONFIG ADD CONSTRAINT FK_AIP_CONFIG_1 FOREIGN KEY (AipServerId) REFERENCES aipdb.dbo.TB_AIP_SERVER(AipServerId);

-- DROP TABLE aipdb.dbo.TB_AIP_API_INFO;
CREATE TABLE aipdb.dbo.TB_AIP_API_INFO (
	ApiId int NOT NULL,
	AipEndPoint varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ApiName varchar(256) COLLATE Korean_Wansung_CI_AS NOT NULL,
	ApiDesc varchar(512) COLLATE Korean_Wansung_CI_AS NULL,
	CONSTRAINT PK_AIP_API_INFO PRIMARY KEY (ApiId)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP API Á¤º¸', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_API_INFO';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP API ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_API_INFO', @level2type=N'Column', @level2name=N'ApiId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP API End Point', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_API_INFO', @level2type=N'Column', @level2name=N'AipEndPoint';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP API À̸§', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_API_INFO', @level2type=N'Column', @level2name=N'ApiName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AIP API ¼³¸í', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_API_INFO', @level2type=N'Column', @level2name=N'ApiDesc';

-- DROP TABLE aipdb.dbo.TB_AIP_FILE_JOB_LOG;
CREATE TABLE aipdb.dbo.TB_AIP_FILE_JOB_LOG (
	Id bigint IDENTITY(1,1) NOT NULL,
	LogDate datetime DEFAULT getdate() NOT NULL,
	ApiId int NOT NULL,
	FileId varchar(64) COLLATE Korean_Wansung_CI_AS NOT NULL,
	FileName varchar(1023) COLLATE Korean_Wansung_CI_AS NOT NULL,
	FileExt varchar(10) COLLATE Korean_Wansung_CI_AS NOT NULL,
	FileOwner varchar(100) COLLATE Korean_Wansung_CI_AS NULL,
	FileLabelGuid varchar(255) COLLATE Korean_Wansung_CI_AS NULL,
	FileProtectionGuid varchar(255) COLLATE Korean_Wansung_CI_AS NULL,
	FileSize bigint NULL,
	NewFileName varchar(1023) COLLATE Korean_Wansung_CI_AS NULL,
	NewFileExt varchar(10) COLLATE Korean_Wansung_CI_AS NOT NULL,
	NewFileOwner varchar(100) COLLATE Korean_Wansung_CI_AS NULL,
	NewFileLabelGuid varchar(255) COLLATE Korean_Wansung_CI_AS NULL,
	NewFileProtectionGuid varchar(255) COLLATE Korean_Wansung_CI_AS NULL,
	NewFileSize bigint NULL,
	ApiGuid varchar(64) COLLATE Korean_Wansung_CI_AS NOT NULL,
	JobOwner varchar(100) COLLATE Korean_Wansung_CI_AS NULL,
	ServerIpAddr varchar(30) COLLATE Korean_Wansung_CI_AS NULL,
	ApiKey varchar(64) COLLATE Korean_Wansung_CI_AS NULL,
	DecryptKey varchar(64) COLLATE Korean_Wansung_CI_AS NULL,
	JobResult int NULL,
	JobTime int NULL,
	JobMessage varchar(MAX) COLLATE Korean_Wansung_CI_AS NULL,
	CONSTRAINT PK_AIP_FILE_JOB_LOG PRIMARY KEY (Id)
);

EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·Î±× ÀϷùøÈ£', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'Id';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·Î±× ÀϽÃ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'LogDate';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ ¸íĪ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ È®ÀåÀÚ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileExt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ ¼ÒÀ¯ÀÚ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileOwner';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ Label GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileLabelGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ º¸È£Á¤Ã¥ GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileProtectionGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÆÄÀÏ »çÀÌÁî', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'FileSize';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ ¸íĪ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileName';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ È®ÀåÀÚ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileExt';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ ¼ÒÀ¯ÀÚ', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileOwner';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ Label GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileLabelGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ º¸È£Á¤Ã¥ GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileProtectionGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½Å±Ô ÆÄÀÏ »çÀÌÁî', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'NewFileSize';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'API GUID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'ApiGuid';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'API ID', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'ApiId';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÀÛ¾÷ ¿äûÀå', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'JobOwner';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿¬°è ¼­¹ö IP Address', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'ServerIpAddr';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'API KEY', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'ApiKey';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'º¹È£È­ Å°', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'DecryptKey';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÀÛ¾÷ °á°ú', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'JobResult';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÀÛ¾÷ ½Ã°£', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'JobTime';
EXEC aipdb.sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÀÛ¾÷ °á°ú ¸Þ½ÃÁö', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'TB_AIP_FILE_JOB_LOG', @level2type=N'Column', @level2name=N'JobMessage';



-- DROP TABLE aipdb.dbo.TB_AIP_API_CALL_LOG;
CREATE TABLE aipdb.dbo.TB_AIP_API_CALL_LOG (
	Id bigint IDENTITY(1,1) NOT NULL,
	LogDate datetime DEFAULT getdate() NOT NULL,
	ApiEndPoint varchar(64) NOT NULL,
	ApiGuid varchar(64) COLLATE Korean_Wansung_CI_AS NOT NULL,
	IPAddress varchar(30) COLLATE Korean_Wansung_CI_AS NULL,
	RequestAt datetime2(3) NULL,
	ResponseAt datetime2(3) NULL,
	ResponseStatusCode int NULL,
	ResponseTime int NULL,
	ErrorCode int NULL,
	ErrorMessage varchar(MAX) COLLATE Korean_Wansung_CI_AS NULL,
	CONSTRAINT PK_AIP_API_CALL_LOG PRIMARY KEY (Id)
);
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'AIP API È£Ãâ Log', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'·Î±× ÀÏ·Ã ¹øÈ£', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'Id';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'·Î±× ÀϽÃ', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'LogDate';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API End Point', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ApiEndPoint';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API GUID', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ApiGuid';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ ½ÃÀÛ ½Ã°¢', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'RequestAt';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ ¿Ï·á ½Ã°¢', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ResponseAt';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ °á°ú', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ResponseStatusCode';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ ÀÛ¾÷ 󸮽ð¢(ms)', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ResponseTime';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ ¼­¹ö IP Address', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'IPAddress';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ °á°ú ¿À·ù ÄÚµå', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ErrorCode';
EXEC aipdb.sys.sp_addextendedproperty 'MS_Description', N'API È£Ãâ °á°ú ¿À·ù ¸Þ½ÃÁö', 'schema', N'dbo', 'table', N'TB_AIP_API_CALL_LOG', 'column', N'ErrorMessage';


°ÔÀÌÆ®¿þÀÌ ·Î±×
¿äûŸÀÔ, IsLabeledOrProtectedFile, GetFileStatus, DeleteLabelOrUnProtected
¿äûÀÚ
¼ÒÀ¯ÀÚ
ÆÄÀϸíx
·¹À̺í ID
Legacy IP
ÆÄÀÏ »çÀÌÁî
¿äû °á°ú
³¯Â¥

±âº»Á¤º¸
³¯Â¥:
¿äû ŸÀÔ:
¼ÒÀ¯ÀÚ:
¿äûÀÚ:
°á°ú: ¼º°ø
³»¿ë: success
ÀÛ¾÷ ÄÚµå: 
°ÔÀÌÆ®¿þÀÌ IP:
±â°£°è IP:
API Key:

MIP ¹®¼­ ¼Ó¼º
·¹À̺í ID:
ÅÛÇø´ ID:
¿ø ¹®¼­ ID:
¹®¼­ ID:

ÆÄÀÏ ¼Ó¼º
ÆÄÀϸí:
¿øº» »çÀÌÁî:
»çÀ̺ê:
Hash:





ÆÀ µ¿±âÈ­ °ü¸®
	ºÎ¼­¸í: ºÎ¼­¸í
	ÆÀ »ý¼º:	Àû¿ë½Ã ÆÀÁî ÆÀÀÌ »ý¼ºµË´Ï´Ù. ÆÀ »ý¼º ¿©ºÎ
	ÇÏÀ§ ºÎ¼­ Æ÷ÇÔ: ÇÏÀ§ ºÎ¼­ÀÇ »ç¿ëÀÚ¸¦ Æ÷ÇÔÇÏ¿© ÆÀÀ» »ý¼ºÇÕ´Ï´Ù. ÇÏÀ§ºÎ¼­ Æ÷ÇÔ ¿©ºÎ
	ÇÏÀ§ ÆÀ »ý¼º: ÇÏÀ§ ¸ðµç ºÎ¼­ÀÇ ÆÀÁî ÆÀÀ» »ý¼ºÇÕ´Ï´Ù. ÇÏÀ§ÆÀ »ý¼º ¿©ºÎ
	»óÀ§ºÎÅÍ Æ÷ÇÔ Á¦¿Ü: »óÀ§ ºÎ¼­Áß¿¡ ÇÏÀ§ ºÎ¼­ Æ÷ÇÔÀÌ Ã¼Å©µÈ °æ¿ì ÇöÀç ºÎ¼­ ¹× ÇÏÀ§ ºÎ¼­¸¦ Æ÷ÇÔÇÏÁö ¾Êµµ·Ï ÇÕ´Ï´Ù. »óÀ§ºÎ¼­ Æ÷ÇÔ Á¦¿Ü ¿©ºÎ
	°âÁ÷ »ç¿ëÀÚ Æ÷ÇÔ Á¦¿Ü: ÆÀ¿¡ °âÁ÷ »ç¿ëÀÚ¸¦ Ãß°¡ÇÏÁö ¾Êµµ·Ï ¼³Á¤ÇÕ´Ï´Ù. °âÁ÷ »ç¿ëÀÚ Æ÷ÇÔ Á¦¿Ü

==> »ç¿ëÀÚ Ãß°¡/»ç¿ëÀÚ »èÁ¦