KDT
Tables (12)
answer
- asno — INT — Primary key — NOT NULL
- tqno — INT — NOT NULL
- cqno — INT — NOT NULL
- rno — INT — NOT NULL
- answer — TEXT
- feedback — TEXT
company
- cpno — INT(10) — Primary key — NOT NULL
- name — VARCHAR(100)
- notice — TEXT
course
- cno — INT(10) — Primary key — NOT NULL
- course_name — VARCHAR(100)
- type — VARCHAR(100)
cover_letter
- clno — INT(10) — Primary key — NOT NULL
- uno — INT — NOT NULL
- jno — INT — NOT NULL
- number — INT
- question — VARCHAR(255)
- answer — TEXT
cover_letter_question
- cqno — INT — Primary key — NOT NULL
- clno — INT — NOT NULL
- number — INT
- question — TEXT
job
- jno — INT — Primary key — NOT NULL
- cpno — INT — NOT NULL
- type — VARCHAR(100)
recommended_company
- cno — INT(10) — NOT NULL
- cpno — INT(10) — NOT NULL
report
- rno — INT — Primary key — NOT NULL
- uno — INT — NOT NULL
- score — INT
- content — TEXT
tech_list
- cno — INT(10) — NOT NULL
- tsno — INT(10) — NOT NULL
tech_question
- tqno — INT(10) — Primary key — NOT NULL
- tsno — INT — NOT NULL
- number — INT
- question — TEXT
tech_skill
- tsno — INT(10) — Primary key — NOT NULL
- tech — VARCHAR(50)
user
- uno — INT(10) — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(100)