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)