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