Design database schema for network logs and origin of network connection

TonyChan1514 / COMP231-001-Team7-F23

COMP231 - Software Development Project 1 (Team 7)

0 stars 0 forks source link

Design database schema for network logs and origin of network connection #35

Open RainyCa opened 8 months ago

RainyCa commented 8 months ago

DB schema created

CREATE TABLE comp231_network_log ( logSeqID NUMBER NOT NULL, access_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, access_ip_address VARCHAR2(15), CONSTRAINT network_log_logSeqID_PK PRIMARY KEY (logSeqID) );

CREATE SEQUENCE seq_logSeqID START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;