todo

Tables (3)

ACCOUNT

  • Key (EMAIL) — varchar2(255) — Primary key — NOT NULL
  • Field (PASSWORD) — varchar2(255)
  • Field (CREATED_AT) — timestamp
  • Field (MODIFIED_AT) — timestamp
  • Field (ACTIVATED) — number

TASK

  • Key (TASK_ID) — number — Primary key — NOT NULL
  • Field (TITLE) — varchar2(255)
  • Field (DESC) — varchar2(255)
  • Field (START_DATE) — timestamp
  • Field (END_DATE) — timestamp
  • Field (ACTIVATED) — number
  • Key (EMAIL) — varchar2(255) — Foreign key → ACCOUNT.Key — NOT NULL
  • Field (CREATED_AT) — timestamp
  • Field (MODIFIED_AT) — timestamp

TASK_IMAGE

  • Key (TASK_IMAGE_ID) — number — Primary key — NOT NULL
  • Field (ORIGIN_FILE_NAME) — varchar2(255)
  • Field (RENAME_FILE_NAME) — varchar(255)
  • Field (SAVE_PATH) — varchar(255)
  • Key (TASK_ID) — number — Foreign key → TASK.Key — NOT NULL
  • Field (MODIFIED_AT) — number
  • Field (ACTIVATED) — number