Mercury

Tables (26)

Mercury_tb_grade (Untitled)

  • idx — VARCHAR — Primary key — NOT NULL
  • endRange — VARCHAR
  • gardeName (gradeName) — VARCAHR
  • gradeOrder — INT
  • insertDate — VARCAHR
  • startRange — VARCAHR

Mercury_tb_history_login (Untitled2)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • accessDate — DATETIME
  • browser — VARCAHR
  • userName — VARCAHR

Mercury_tb_history_request (Untitled3)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • browser — VARCAHR
  • ip — VARCAHR
  • message — TEXT
  • method — VARCAHR
  • requestDate — DATETIME
  • requestUrl — VARCAHR
  • username — VARCAHR

Mercury_tb_history_schedule (Untitled4)

  • idx — VARCAHR
  • cron — VARCAHR
  • jobName — VARCAHR
  • message — TEXT
  • scheduleName — VARCAHR
  • startDate — DATETIME
  • triggerName — VARCAHR
  • type — VARCAHR
  • scheduleIdx — VARCHAR — Foreign key → Mercury_tb_quartz_schedule.idx — NOT NULL
  • triggerIdx — VARCHAR — Foreign key → Mercury_tb_quartz_schedule.triggerIdx — NOT NULL
  • jobIdx — VARCHAR — Foreign key → Mercury_tb_quartz_schedule.jobIdx — NOT NULL

Mercury_tb_honor (Untitled5)

  • idx — VARCHAR — Primary key — NOT NULL
  • contentIdx (twoContentIdx) — VARCHAR — Foreign key → Mercury_tb_two.idx — NOT NULL
  • contentIdx (threeContentIdx) — VARCHAR — Foreign key → Mercury_tb_three.idx — NOT NULL
  • contentOne — VARCAHR
  • contentTwo — VARCAHR
  • contentThree — VARCAHR
  • createDate — DATETIME
  • endDate — VARCAHR
  • point — INT
  • startDate — VARCAHR
  • userName — VARCAHR
  • word — VARCAHR
  • month — INT
  • pidx — VARCAHR
  • weeks — INT
  • year — INT
  • description — VARCAHR

Mercury_tb_love (Untitled6)

  • idx — VARCHAR — Primary key — NOT NULL
  • contentIdx (twoContentIdx) — VARCHAR — Foreign key → Mercury_tb_two.idx — NOT NULL
  • contentIdx (threeContentIdx) — VARCHAR — Foreign key → Mercury_tb_three.idx — NOT NULL
  • contentIdx — VARCAHR
  • insertDate — VARCAHR
  • userIdx — VARCAHR

Mercury_tb_mail_template (Untitled7)

  • idx — VARCAHR
  • insertDate — VARCAHR
  • tempName — VARCAHR
  • title — VARCAHR
  • type — VARCAHR

Mercury_tb_menu (Untitled8)

  • idx — VARCAHR
  • child — INT
  • insertDate — VARCAHR
  • level — INT
  • menuGroup — VARCAHR
  • menuOrder — VARCAHR
  • parent — VARCAHR
  • roleIdx — VARCAHR
  • roleTitle — VARCAHR
  • title — VARCAHR
  • url — VARCAHR

Mercury_tb_mileage (Untitled9)

  • idx — VARCHAr — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • paymentDate — VARCAHR
  • userName — VARCAHR
  • content — VARCAHR
  • paymentMileage — VARCHAR

Mercury_tb_mileage_request (Untitled10)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • account — VARCHAR
  • approval — BIT
  • bank — VARCHAR
  • paymentDate — VARCHAR
  • prevMileage — INT
  • userName — VARCHAR
  • withDrawMileage — INT
  • withDrawDate — VARCHAR

Mercury_tb_newsletter (Untitled11)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • subscribeDate — VARCHAR
  • userEMail — VARCHAR
  • userName — VARCHAR

Mercury_tb_notice (Untitled12)

  • idx — VARCHAR — Primary key — NOT NULL
  • content — VARCHAR
  • insertDate — VARCHAR
  • title — VARCHAR
  • type — BIT

Mercury_tb_quartz_job (Untitled13)

  • idx — VARCHAR — Primary key — NOT NULL
  • clasz — VARCHAR
  • description — VARCHAR
  • insertDate — VARCHAR
  • name — VARCHAR
  • title — VARCHAR
  • execute — BIT

Mercury_tb_quartz_schedule (Untitled14)

  • idx — VARCHAR — Primary key — NOT NULL
  • triggerIdx — VARCHAR — Foreign key → Mercury_tb_quartz_trigger.idx — NOT NULL
  • jobIdx — VARCHAR — Foreign key → Mercury_tb_quartz_job.idx — NOT NULL
  • insertDate — VARCHAR
  • name — VARCHAR

Mercury_tb_quartz_trigger (Untitled15)

  • idx — VARCHAR — Primary key — NOT NULL
  • cron — VARCHAR
  • description — VARCHAR
  • insertDate — VARCHAR
  • jobIdx — VARCHAR
  • name — VARCHAR
  • title — VARCHAR

Mercury_tb_role (Untitled16)

  • idx — VARCHAR — Primary key — NOT NULL
  • changeDate — VARCHAR
  • insertDate — VARCHAR
  • roleName — VARCHAR

Mercury_tb_system_config (Untitled17)

  • configName — VARCHAR
  • configType — VARCHAR
  • configValue — VARCHAR

Mercury_tb_three (Untitled18)

  • idx — VARCHAR — Primary key — NOT NULL
  • contentOne — VARCHAR
  • contentTwo — VARCHAR
  • contentThree — VARCHAR
  • insertDate — VARCHAR
  • love — BIT
  • loveName — VARCHAR
  • point — INT
  • updateDate — VARCHAR
  • userIdx — VARCHAR
  • userName — VARCHAR
  • word — VARCHAR
  • wordIdx — VARCHAR

Mercury_tb_token_block (Untitled19)

  • idx — VARCHAR
  • insertDate — VARCHAR
  • token — VARCHAR

Mercury_tb_token_refresh (Untitled20)

  • userName — VARCHAR
  • insertDate — VARCHAR
  • token — VARCHAR

Mercury_tb_two (Untitled21)

  • idx — VARCHAR — Primary key — NOT NULL
  • contentOne — VARCHAR
  • contentTwo — VARCHAR
  • insertDate — VARCHAR
  • love — BIT
  • loveName — VARCHAR
  • point — VARCHAR
  • updateDate — VARCHAR
  • userIdx — VARCHAR
  • userName — VARCHAR
  • word — VARCHAR
  • wordIdx — VARCHAR

Mercury_tb_user (Untitled22)

  • idx — VARCHAR — Primary key — NOT NULL
  • changeDate — VARCHAR
  • email — VARCHAR
  • insertDate — VARCHAR
  • mileage — VARCHAR
  • password — VARCHAR
  • sns — VARCHAR
  • username — VARCHAR
  • newPassword — VARCHAR

Mercury_tb_user_grade (Untitled23)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • gradeIdx — VARCHAR — Foreign key → Mercury_tb_grade.idx — NOT NULL
  • gradeName — VARCHAR
  • userName — VARCHAR

Mercury_tb_user_notice (Untitled24)

  • idx — VARCHAR — Primary key — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • noticeIdx — VARCHAR — Foreign key → Mercury_tb_notice.idx — NOT NULL
  • noticeTitle — VARCHAR
  • userName — VARCHAR

Mercury_tb_user_role (Untitled25)

  • idx — VARCHAR — Primary key — NOT NULL
  • roleIdx — VARCHAR — Foreign key → Mercury_tb_role.idx — NOT NULL
  • userIdx — VARCHAR — Foreign key → Mercury_tb_user.idx — NOT NULL
  • roleName — VARCHAR
  • userName — VARCHAR

Mercury_tb_word (Untitled26)

  • idx — VARCHAR — Primary key — NOT NULL
  • contentIdx (twoContentIdx) — VARCHAR — Foreign key → Mercury_tb_two.idx — NOT NULL
  • contentIdx (threeContentIdx) — VARCHAR — Foreign key → Mercury_tb_three.idx — NOT NULL
  • description — VARCHAR
  • endDate — VARCHAR
  • insertDate — VARCHAR
  • startDate — VARCHAR
  • word — VARCHAR
  • wordGroup — VARCHAR
  • month — INT
  • weeks — INT
  • year — INT