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