benefito
Tables (10)
chat_messages
- id — BIGSERIAL — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_rooms
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
common_codes
- id — BIGSERIAL — Primary key — NOT NULL
- code_type — VARCHAR(30) — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- display_order — INTEGER — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
posting_embeddings
- id — BIGSERIAL — Primary key — NOT NULL
- posting_id — BIGINT — Foreign key → postings.id — NOT NULL
- embedding — vector(1536) — NOT NULL
- model_name — VARCHAR(100) — NOT NULL
- dimensions — INTEGER — NOT NULL
- embedded_text_hash — VARCHAR(64) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
posting_tags
- id — BIGSERIAL — Primary key — NOT NULL
- posting_id — BIGINT — Foreign key → postings.id — NOT NULL
- tag_name — VARCHAR(50) — NOT NULL
postings
- id — BIGSERIAL — Primary key — NOT NULL
- category_code_id — BIGINT — Foreign key → common_codes.id — NOT NULL
- region_code_id — BIGINT — Foreign key → common_codes.id
- title — VARCHAR(200) — NOT NULL
- company — VARCHAR(100)
- content — TEXT
- end_date — DATE
- enterprise_type — VARCHAR(50)
- employment_type — VARCHAR(50)
- salary — VARCHAR(100)
- qualification — TEXT
- homepage_url — VARCHAR(255)
- view_count — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
scraps
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- posting_id — BIGINT — Foreign key → postings.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
todos
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — VARCHAR(255) — NOT NULL
- due_date — DATE
- category — VARCHAR(30)
- is_checked — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_interests
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- category_code_id — BIGINT — Foreign key → common_codes.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- school — VARCHAR(100)
- major — VARCHAR(100)
- birth_date — DATE
- grade — VARCHAR(30)
- region_code_id — BIGINT — Foreign key → common_codes.id
- income — VARCHAR(30)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP