oracle Íâ¼üÔ¼Êø¼Ó´¥·¢Æ÷ÎÊÌ⣿ - Oracle / ·Ç¼¼ÊõÇø

SQL code:

create table user_file (
userID int not null,
userName VARCHAR2(10),
userPwd VARCHAR2(10),
primary key (userID)
);

create table articletype (
magazineType int not null,
magazienTypeName VARCHAR2(20) not null,
primary key (magazineType)
);

create table article (
authorID int not null,
artcleName VARCHAR2(20) not null,
reportDate DATE,
magazine VARCHAR2(20),
magazineType int,
authorOrder int,
extend VARCHAR2(100),
foreign key (authorID) references user_file(userID)on delete

cascade,
foreign key (magazineType) references articletype(magazineType) on

delete cascade
);

create table log_file (
userID int not null,
operater VARCHAR2(10),
operaterDest VARCHAR2(20),
operaterDate DATE,
foreign key (userID) references user_file(userID)
);



Ç°ÃæÊÇÎÒ½¨µÄ±í£¬ÏÂÃæÊÇÎÒ½¨µÄ´¥·¢Æ÷
SQL code:

--ÂÛÎĸüд¥·¢Æ÷
CREATE OR REPLACE TRIGGER article_log_file
BEFORE INS