WhiteBoard

Tables (5)

Untitled (tbl_alarm)

  • Key (user_no) — number — Primary key — NOT NULL
  • Field (user_time) — varchar2 — NOT NULL
  • Field2 (alarm_contents) — varchar2

Untitled (tbl_memo)

  • Key (user_no) — number — Primary key — NOT NULL
  • Key2 (memo_no) — number — Primary key — NOT NULL
  • Field (user_time) — varchar2 — NOT NULL
  • Field (memo_subject) — varchar2
  • Field (memo_contents) — varchar2

Untitled (tbl_checklist)

  • Key (user_no) — number — Primary key — NOT NULL
  • Key2 (check_no) — number — Primary key — NOT NULL
  • Field (user_time) — varchar2 — NOT NULL
  • Field (check_subject) — varchar2
  • Field (check_contents) — varchar2

Untitled (tbl_cldar)

  • Key (cldar_no) — number — Primary key — NOT NULL
  • Key (user_no) — number — Primary key — NOT NULL
  • Field (user_time) — varchar2 — NOT NULL
  • Field (cldar_subject) — varchar2
  • Field2 (cldar_contents) — varchar2

tbl_user

  • Key (user_no) — number — Primary key — NOT NULL
  • Field (user_email) — varchar2 — NOT NULL — unique
  • Field (user_pass) — varchar2 — NOT NULL
  • Field2 (user_regdate) — varchar2
  • Field3 (user_name) — varchar2
  • Field4 (user_birthday) — varchar2