ASD
Tables (9)
bookmark
- BOOKMARK_NO — INT — Primary key — NOT NULL
- USER_NO — INT — Foreign key — NOT NULL
- LOG_NO — INT — Foreign key — NOT NULL
comment
- COMMENT_NO — INT — Primary key — NOT NULL
- USER_NO — INT — Foreign key — NOT NULL
- LOG_NO — INT — Foreign key — NOT NULL
- CONTENT — TEXT
- IS_DEL — BOOLEAN
- PARENT_COMMENT_NO — INT
- CREATED_DATE — DATETIME
employment_certificate
- CERTIFICATE_NO — INT — Primary key — NOT NULL
- USER_NO — INT — Foreign key — NOT NULL
- COMPANY_NAME — VARCHAR(100) — NOT NULL
- UPLOAD_DATE — DATETIME — NOT NULL
- FILE_PATH — VARCHAR(255) — NOT NULL
- UPDATE_DATE — DATETIME
- STATUS — VARCHAR(20) — NOT NULL
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 — NOT NULL
- TAG_NO — INT — Foreign key — NOT NULL
report
- REPO_NO — INT — Primary key — NOT NULL
- USER_NO — INT — Foreign key — NOT NULL
- REPO_REASON — VARCHAR(255) — NOT NULL
- REPO_DATE — DATETIME — NOT NULL
- IS_DEL — TINYINT(1) — NOT NULL
- LOG_NO — INT — Foreign key — 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)
- COMPANY_NAME — VARCHAR(100)