test
Tables (11)
t_center
- center_id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(45) — Primary key
- name — VARCHAR(255)
- address — VARCHAR(255)
- address_detail — VARCHAR(255)
- contact — VARCHAR(255)
- region — VARCHAR(255)
- wide — VARCHAR(255)
- base_name — VARCHAR(255)
- type — VARCHAR(45)
- operation — VARCHAR(45)
- member_id — BIGINT — Foreign key → t_member.member_id — NOT NULL
t_confirm
- confirm_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- date — VARCHAR(255)
- status — INT — NOT NULL
- option — TINYINT — NOT NULL
- comment — VARCHAR(1024)
- paymentStatus — INT — NOT NULL
- manager_comment — VARCHAR(255)
- intern_accept_at — DATETIME
- manager_accept_at — DATETIME
- admin_accept_at — DATETIME
- work_result1 — INT
- work_result2 — INT
- work_result3 — INT
- work_resultTotal — INT
- ability_result1 — INT
- ability_result2 — INT
- ability_result3 — INT
- ability_result4 — INT
- ability_resultTotal — INT
- attitude — INT
- tardy — INT
- absenteeism — INT
- unkind — INT
- punishment — INT
- warning — INT
- without — INT
- no_education — INT
- total — INT
- job — VARCHAR(45)
- manager — VARCHAR(45)
- total_comment — VARCHAR(255)
- content — VARCHAR(255)
- member_id (member_id2) — BIGINT — Foreign key → t_member.member_id — NOT NULL
t_confirm_log
- id — BIGINT — Primary key — NOT NULL
- type — INT — NOT NULL
- create_at — DATETIME — NOT NULL
- member_id — BIGINT — NOT NULL
- confirm_id — BIGINT — NOT NULL
- content — VARCHAR(512)
- name — VARCHAR(45)
- member_id (member_id2) — BIGINT — Foreign key → t_member.member_id — NOT NULL
t_document
- document_id — BIGINT — Primary key — NOT NULL
- schedule_id — BIGINT — NOT NULL
- type — INT — NOT NULL
- name — VARCHAR(255)
- url — VARCHAR(255)
- schedule_id (schedule_id2) — BIGINT — Foreign key → t_schedule.schedule_id — NOT NULL
- Key — Foreign key → t_schedule.Key — NOT NULL
t_faq
- faq_id — BIGINT — Primary key — NOT NULL — id
- faq_type — INT — NOT NULL — type
- question — VARCHAR(255) — 질문
- answer — VARCHAR(1000) — 답변
- create_at — DATETIME — 생성일
t_inquery
- inq_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL — 계정 id
- member_username — VARCHAR(255) — 작성자
- title — VARCHAR(255) — 제목
- question — VARCHAR(1000) — 질문
- answer — VARCHAR(1000) — 답변
- answer_username — VARCHAR(255) — 답변자
- answer_at — DATETIME — 답변 날짜
- create_at — DATETIME — 생성일
- secret — TINYINT — NOT NULL — 비밀글
- delete_yn — TINYINT — 삭제 유무
- INDEX — `member_idx`
- member_id (member_id2) — BIGINT — Foreign key → t_member.member_id — NOT NULL
t_member
- member_id — BIGINT — Primary key — NOT NULL
- account — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- address — VARCHAR(255)
- contact — VARCHAR(255)
- manager — INT — NOT NULL
- role — INT — NOT NULL
- refresh_token — VARCHAR(255)
- address_detail — VARCHAR(255)
- email — VARCHAR(45)
- education — INT — NOT NULL
- create_at — DATETIME
- center — BIGINT — NOT NULL
- status — INT — NOT NULL
- passwordExpire — DATETIME
- centerCode — VARCHAR(45)
- status_at — DATETIME
t_notice
- notice_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255)
- content — VARCHAR(4255)
- create_at — DATETIME — NOT NULL
- intern — TINYINT — NOT NULL
- center — TINYINT — NOT NULL
t_refresh_token
- token_id — BIGINT — Primary key — NOT NULL
- token — VARCHAR(255)
- expire_at — DATETIME — NOT NULL
- member_id — BIGINT — NOT NULL
- revoked_at — DATETIME — NOT NULL
- revoked_ip — VARCHAR(255)
- create_at — DATETIME — NOT NULL
- created_by_ip — VARCHAR(255)
t_schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- member_id — BIGINT — NOT NULL
- type — INT — NOT NULL
- year — INT — NOT NULL
- month — INT — NOT NULL
- day — INT — NOT NULL
- content — VARCHAR(1024)
- days — INT — NOT NULL
- hours — INT — NOT NULL
- start — DATETIME — NOT NULL
- end — DATETIME — NOT NULL
- status — INT — NOT NULL
- create_at — DATETIME
- source — VARCHAR(255)
- destination — VARCHAR(255)
- travelExpenses — TINYINT — NOT NULL
- value — INT — NOT NULL
- parameter — VARCHAR(255)
- date — VARCHAR(45)
- member_id (member_id2) — BIGINT — Foreign key → t_member.member_id — NOT NULL
- Field
t_setting_month
- id — BIGINT — Primary key — NOT NULL
- date_at — DATETIME — NOT NULL
- start_at — DATETIME
- end_at — DATETIME
- total_works — INT — NOT NULL