venus
Tables (26)
administrator
- adminId — varchar(50) — Primary key — NOT NULL
- password — varchar(50)
- name — varchar(50)
- nameEng — varchar(50)
- rrn — varchar(50)
- enteredDate — date
- birthDate — date
- buseo — varchar(50)
- zikwi — varchar(50)
- zikcheck — varchar(50)
- zikgeop — varchar(50)
- phone — varchar(50)
- emergencyContact — varchar(50)
- email — varchar(50)
- address — varchar(50)
- profileImg — varchar(50)
- authority — varchar(50)
- workingStatus — varchar(50)
apply
- applyId — int(11) — Primary key — NOT NULL
- memberId — varchar(50) — Foreign key → member.memberId
- jobInfoId — int(11) — Foreign key → jobinfo.id
- cvId — int(11) — Foreign key → cv.cvId
- registerDate — date
- status — varchar(50)
- resultDate — date
bank
- bankId — int(11) — Primary key — NOT NULL
- bankName — varchar(50)
buseo
- buseoId — int(11) — Primary key — NOT NULL
- buseoName — varchar(50)
certificate
- certificateNum — int(10) — Primary key — NOT NULL
- userId — varchar(50) — Foreign key → member.memberId — NOT NULL
- email — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- purpose — varchar(255) — NOT NULL
- etc — varchar(255) — NOT NULL
- situation — varchar(255) — NOT NULL
- date — date — NOT NULL
- filename — varchar(255)
company
- companyId — varchar(50) — Primary key — NOT NULL
- companyCode — int(11) — NOT NULL
- crn — varchar(50)
- password — varchar(50)
- companyName — varchar(50)
- ceoName — varchar(50)
- phone — varchar(50)
- fax — varchar(50)
- address — varchar(50)
- managerName — varchar(50)
- managerEmail — varchar(50)
- managerPhone — varchar(50)
- uptaeId — int(11) — Foreign key → uptae.uptaeId
- jikjongId — int(11) — Foreign key → jikjong.jikjongId — 희망구인분야
- homepageUrl — varchar(50)
consult
- consultNum — int(10) — Primary key — NOT NULL
- userName — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- type — varchar(255) — NOT NULL
- content — text — NOT NULL
- date — date — NOT NULL
- situation — varchar(255) — NOT NULL
- answer — text
cv
- cvId — int(11) — Primary key — NOT NULL
- memberId — varchar(50) — Foreign key → member.memberId
- cvName — varchar(50)
- cvPath — varchar(50)
- date — date
deductible
- deductibleId — int(11) — Primary key — NOT NULL
- deductibleName — varchar(50)
faq
- faqNum — int(10) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- hit — int(11) — NOT NULL
- date — date — NOT NULL
- file — varchar(255)
faq_reply
- idx — int(11) — Primary key — NOT NULL
- faq_num — int(11) — NOT NULL
- userId — varchar(255) — NOT NULL
- content — text — NOT NULL
- date — date — NOT NULL
jikjong
- jikjongId — int(11) — Primary key — NOT NULL
- jikjongName — varchar(50)
jobinfo
- id — int(11) — Primary key — NOT NULL
- companyCode — int(11) — Foreign key → company.companyCode
- companyName — varchar(255) — NOT NULL
- workPosition — varchar(255) — NOT NULL
- workPlace — varchar(255) — NOT NULL
- region — varchar(255) — NOT NULL
- subRegion — varchar(255) — NOT NULL
- applyNumber — varchar(255) — NOT NULL
- dueDate — timestamp — NOT NULL
- date — date — NOT NULL
- contents — longtext — NOT NULL
- managerName — varchar(255) — NOT NULL
- managerPhone — varchar(255) — NOT NULL
- managerEmail — varchar(255) — NOT NULL
- status — varchar(50)
- jikjong — int(11) — Foreign key → jikjong.jikjongId
member
- memberId — varchar(50) — Primary key — NOT NULL
- password — varchar(50)
- name — varchar(50)
- email — varchar(50)
- birthDate — date
- phone — varchar(50)
- address — varchar(50)
- profileImg — varchar(50)
- hopeArea — varchar(50)
- hopeField — int(11) — Foreign key → jikjong.jikjongId
membertype
- typeId — int(11) — Primary key — NOT NULL
- typeName — varchar(50)
news
- newsNum — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- hit — int(10) — NOT NULL
- date — date — NOT NULL
notice
- noticeNum — int(11) — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- hit — int(11) — NOT NULL
- date — date — NOT NULL
payment
- paymentId — int(11) — Primary key — NOT NULL
- paymentName — varchar(50)
qna
- qnaNum — int(10) — Primary key — NOT NULL
- userId — varchar(50) — Foreign key → member.memberId
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- hit — int(10) — NOT NULL
- date — date — NOT NULL
- file — varchar(255)
- answerCheck — varchar(10) — NOT NULL
qna_answer
- idx — int(11) — Primary key — NOT NULL
- qna_num — int(11) — Foreign key → qna.qnaNum — NOT NULL
- manager — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- hit — int(11) — NOT NULL
- date — date — NOT NULL
- file — varchar(255)
qna_reply
- idx — int(11) — Primary key — NOT NULL
- qna_num — int(11) — Foreign key → qna.qnaNum — NOT NULL
- userId — varchar(255) — NOT NULL
- content — text — NOT NULL
- date — date — NOT NULL
region
- regionId — int(11) — Primary key — NOT NULL
- regionName — varchar(50)
regularmember
- rmId — int(11) — Primary key — NOT NULL
- memberId — varchar(50) — Foreign key → member.memberId
- jobInfoCode — int(11) — Foreign key → jobinfo.id
- companyCode — int(11) — Foreign key → jobinfo.companyCode
- buseoId — int(11) — Foreign key → buseo.buseoId
- bankName — varchar(50)
- account — varchar(50)
- accountHolder — varchar(50)
- workPosition — varchar(50)
- workPlace — varchar(50)
- enteredDate — date
- memberType — int(11) — Foreign key → membertype.typeId
salary_history
- historyId — int(11) — Primary key — NOT NULL
- year — varchar(50) — NOT NULL
- month — varchar(50) — NOT NULL
- memberId — int(11) — Foreign key → regularmember.rmId
- totalSalary — varchar(50)
- totalPayment — varchar(50)
- totalDeductible — varchar(50)
- paymentId — longtext
- deductibleId — longtext
- accountHolder — varchar(50)
- bankName — varchar(50)
- account — varchar(50)
uptae
- uptaeId — int(11) — Primary key — NOT NULL
- uptaeName — varchar(50)
visit
- date — date — Primary key — NOT NULL
- count — int(11) — NOT NULL