Q1Q
Tables (9)
bookmark
- BOOKMARK_NO — int — Primary key — NOT NULL — auto_increment, PK
- USER_NO — int — Foreign key → user.USER_NO — NOT NULL — FK
- LOG_NO — int — Foreign key → log.LOG_NO — NOT NULL — FK
comment
- COMMENT_NO — INT — Primary key — NOT NULL
- CREATED_DATE — datetime — NOT NULL
- LOG_NO — int — Foreign key → log.LOG_NO — NOT NULL
- CONTENT — TEXT
- IS_DEL — BOOLEAN — NOT NULL
- USER_NO — int — Foreign key → user.USER_NO — NOT NULL
- PARENT_COMMENT_NO — VARCHAR(50)
employment_certificate
- CERTIFICATE_NO — int — Primary key — NOT NULL — auto_increment, PK
- USER_NO — int — Foreign key → user.USER_NO — NOT NULL — T: 긍 / F: 부
- COMPANY_NAME — varchar(100) — NOT NULL — auto_increment, PK
- UPLOAD_DATE — datetime — NOT NULL
- FILE_PATH — varchar(255) — NOT NULL
- UPDATE_DATE — datetime
- STATUS — varchar(20) — NOT NULL — 0:회원 1:관리자
jobpost
- id — int — Primary key — NOT NULL
- active — int — NOT NULL
- url — varchar(255) — NOT NULL
- company_name — varchar(100) — NOT NULL
- title — varchar(255) — NOT NULL
- opening_date — datetime — NOT NULL
- expiration_date — datetime — NOT NULL
- location — varchar(255)
- job_code — text
- job_code_name — text
- experience_level — int
- experience_level_name — varchar(255)
log
- LOG_NO — int — Primary key — NOT NULL
- CONTENT — text — NOT NULL
- VAL_TEXT — varchar(255) — NOT NULL
- IS_DEL — tinyint(1) — NOT NULL
- REPO_COUNT — int — NOT NULL
- CREATED_DATE — datetime — NOT NULL
- EDITED_DATE — date
- COMPANY_NAME — varchar(100)
- IS_CURRENTLY_EMPLOYED — tinyint(1)
- TITLE — varchar(255)
- VIEW_COUNT — INT
post_tag
- LOG_NO — int — Foreign key → log.LOG_NO — NOT NULL
- TAG_NO — int — Foreign key → tag.TAG_NO — NOT NULL
report
- REPO_NO — INT — Primary key — NOT NULL
- USER_NO — int — Foreign key → user.USER_NO — NOT NULL
- REPO_REASON — varchar(255) — NOT NULL
- REPO_DATE — datetime — NOT NULL
- IS_DEL — tinyint(1) — NOT NULL
- LOG_NO — int — Foreign key → log.LOG_NO — NOT NULL
tag
- TAG_NO — int — Primary key — NOT NULL
- TAG_NP — TINYINT
- TAG_CONTENT — VARCHAR(100)
user
- USER_NO — int — Primary key — NOT NULL
- PASSWORD — varchar(100) — NOT NULL
- NICKNAME — varchar(100) — NOT NULL
- EMAIL — varchar(100)
- CREATED_DATE — datetime — NOT NULL
- IS_DEL — tinyint(1) — NOT NULL
- ROLE — int — NOT NULL
- USER_ID — VARCHAR(100)
- VARCHAR — VARCHAR(100)