hh
Tables (11)
Untitled
- id — BIGSERIAL — Primary key — NOT NULL
- post_id — BIGSERIAL — NOT NULL
- member_id — BIGSERIAL — NOT NULL
- created_at — TIMESTAMP
agency
- id — BIGSERIAL — Primary key — NOT NULL
- agency_name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL — 등록일시
bid_announcement
- id — BIGSERIAL — Primary key — NOT NULL
- inst_id — BIGSERIAL — NOT NULL
- job_posting_id — BIGSERIAL — NOT NULL
- nara_sn — VARCHAR(200) — NOT NULL — 나라장터
- title — VARCHAR(300) — NOT NULL
- bid_type — VARCHAR(20) — NOT NULL
- announce_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- estimated_amount — BIGINT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
bid_entry
- id — BIGSERIAL — Primary key — NOT NULL
- agency_id — BIGSERIAL — NOT NULL
- bid_anno_id — BIGSERIAL — NOT NULL
- amount — BIGINT
- rank — INT
- entered_at — TIMSTAMP — NOT NULL
- is_selected — BOOLEAN
- created_at — TIMSTAMP — NOT NULL
favorite_institution
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGSERIAL — NOT NULL
- inst_id — BIGSERIAL — NOT NULL
- created_at — TIMESTAMP
favorite_job_posting
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGSERIAL — NOT NULL
- job_posting_id — BIGSERIAL — NOT NULL
- created_at — TIMESTAMP
institution
- id — BIGSERIAL — Primary key — NOT NULL
- code — VARCHAR(30)
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(30)
- ministry — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
job_posting
- id — BIGSERIAL — Primary key — NOT NULL
- institution_id — BIGSERIAL — NOT NULL
- source_posting_id — VARCHAR(50) — NOT NULL
- title — VARCHAR(300) — NOT NULL
- hire_type — VARCHAR(30)
- recruit_type — VARCHAR(30)
- edu_req — VARCHAR(100)
- work_region — VARCHAR(50)
- recruit_count — INT
- start_date — DATE
- end_date — DATE
- ncs_yn — BOOLEAN — NOT NULL
- ncs_codes — VARCHAR(200)
- process_desc — TEXT
- status — VARCHAR(20) — NOT NULL
- source_url — VARCHAR(500)
- source_type — VARCHAR(20) — NOT NULL — ALIO
- created_at — TIMESTAMP — NOT NULL
member
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50)
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN(1)
- provider — VARCHAR(50) — 구글
- provider_id — VARCHAR(255) — 소셜에서
- profile_img — VARCHAR(200)
post
- id — BIGSERIAL — Primary key — NOT NULL
- job_posting_id — BIGSERIAL — NOT NULL
- inst_id — BIGSERIAL — NOT NULL
- category — VARCHAR(30) — 시험후기
- title — VARCHAR(200)
- content — TEXT
- view — INT
- like — INT
- status — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
post_comment
- id — BIGSERIAL — Primary key — NOT NULL
- member_id — BIGSERIAL — NOT NULL
- post_id — BIGSERIAL — NOT NULL
- comment_parent_id — BIGSERIAL — NOT NULL
- content — VARCHAR
- is_deleted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP