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