swtodo

Tables (7)

NDepartment

  • department — varchar(255) — Primary key — NOT NULL

NJReview

  • review_pk — int(11) — Primary key — NOT NULL
  • review_content — varchar(255)
  • review_udate — datetime(6)
  • journal_pk — int(11) — Foreign key → NJournal.journal_pk
  • user_id — varchar(255) — Foreign key → NUser.user_id

NJournal

  • journal_pk — int(11) — Primary key — NOT NULL
  • journal_content_next — varchar(255)
  • journal_content_now — varchar(255)
  • journal_date — datetime(6)
  • journal_title — varchar(255)
  • journal_udate — datetime(6)
  • user_id — varchar(255) — Foreign key → NUser.user_id

NRank

  • rank_pk — int(11) — Primary key — NOT NULL
  • rank — varchar(255)

NSite

  • site_pk — int(11) — Primary key — NOT NULL
  • site_name — varchar(255)
  • site_officer — varchar(255)
  • site_call — varchar(255)
  • site_loc — varchar(255)

NSiteHistory

  • history_pk — int(11) — Primary key — NOT NULL
  • history_title — varchar(255)
  • history_content — varchar(255)
  • history_date — datetime(6)
  • site_pk — int(11) — Foreign key → NSite.site_pk
  • history_type — int(11)

NUser

  • user_id — varchar(255) — Primary key — NOT NULL
  • user_email — varchar(255)
  • user_img — varchar(255)
  • user_leave — bit(1)
  • user_name — varchar(255)
  • user_phone — varchar(255)
  • user_pw — varchar(255)
  • user_role — varchar(255)
  • user_department — varchar(255) — Foreign key → NDepartment.department
  • user_rank_pk — int(11) — Foreign key → NRank.rank_pk