calen
Tables (5)
account (Account Information)
- username (PK (username)) — VARCHAR2(50) — Primary key — NOT NULL
- password (Encrypted password) — VARCHAR2(50)
- first_name (First name) — VARCHAR2(50)
- last_name (Last name) — VARCHAR2(50)
- email (Email) — VARCHAR2(50)
- account_status (Account status) — VARCHAR2(50)
- account_type (Account type) — VARCHAR2(50)
- reg_date (Registration date) — DATE
account_auth (Account Authentication)
- username (FK (username)) — VARCHAR2(50) — Foreign key → account.username — NOT NULL
- auth (Authentication) — VARCHAR2(50)
log (Log Information)
- log_no (PK (sequence)) — NUMBER — Primary key — NOT NULL
- username (FK (username)) — VARCHAR2(50) — Foreign key → account.username — NOT NULL
- log_title (Log title) — VARCHAR2(200) — NOT NULL
- log_description (Log description) — VARCHAR2(4000)
- log_entry_date (Log entry stamp) — DATE
- log_mod_date (Log change stamp) — DATE
- log_start_date (Log start time) — DATE
- log_end_date (Log end time) — DATE
- log_status (Log status) — VARCHAR2(50)
log_tag (Log / Tag Relationship)
- tag_no (PK (sequence)) — NUMBER — Foreign key → tag.tag_no — NOT NULL
- log_no (PK (sequence)2) — NUMBER — Foreign key → log.log_no — NOT NULL
tag (Tag Information)
- tag_no (PK (sequence)) — NUMBER — Primary key — NOT NULL
- username (FK (username)) — VARCHAR2(50) — Foreign key → account.username — NOT NULL
- tag_name (Tag name) — VARCHAR2(30)
- tag_count (Tag count) — NUMBER
- tag_minutes (Tag minutes) — NUMBER
- tag_color (Tag color) — VARCHAR2(50)