grrr

Tables (7)

acction_history (물건이력(스냅샷용))

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — NOT NULL
  • snapshot_time (Field) — TIMESTAMP — NOT NULL
  • min_bid_price (Field2) — BIGINT — NULL
  • num_failures (Field3) — INT — NULL
  • status (Field4) — VARCHAR(30) — NULL
  • id (Key2) — BIGSERIAL — Foreign key → auction_item.id — NOT NULL — NOT NULL

alert_preference (유저 관심 조건)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — NOT NULL
  • region (Field) — VARCHAR(100) — NULL
  • large_category (Field12) — VARCHAR(20) — NOT NULL
  • mid_categories (Field13) — TEXT — NOT NULL
  • small_categories (Field11) — TEXT — NOT NULL
  • min_price (Field2) — BIGINT — NULL
  • max_price (Field3) — BIGINT — NULL
  • min_failures (Field4) — INT — NOT NULL
  • notify_email (Field5) — BOOLEAN — NOT NULL
  • notify_telegram (Field6) — BOOLEAN — NOT NULL
  • frequency (Field7) — VARCHAR(20) — NOT NULL
  • is_active (Field8) — BOOLEAN — NOT NULL
  • created_at (Field9) — TIMESTAMP — NOT NULL
  • updated_at (Field10) — TIMESTAMP — NOT NULL
  • id (Key2) — BIGSERIAL — Foreign key → user.id — NOT NULL — PK, NOT NULL

auction_item (경매 물건)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — NOT NULL
  • source (Field) — VARCHAR(20) — NOT NULL
  • external_id (Field2) — VARCHAR(100) — NOT NULL
  • large_category (Field3) — VARCHAR(20) — NOT NULL
  • mid_category (Field4) — VARCHAR(20) — NULL
  • small_category (Field5) — VARCHAR(20) — NULL
  • raw_large_code (Field6) — VARCHAR(20) — NULL
  • raw_large_name (Field7) — VARCHAR(50) — NULL
  • raw_mid_code (Field8) — VARCHAR(20) — NULL
  • raw_mid_name (Field9) — VARCHAR(50) — NULL
  • raw_small_code (Field10) — VARCHAR(20) — NULL
  • raw_small_name (Field11) — VARCHAR(50) — NULL
  • title (Field12) — VARCHAR(200)
  • location (Field13) — TEXT — NOT NULL
  • area_m2 (Field14) — NUMERIC(10,2)
  • appraised_price (Field15) — BIGINT — NULL
  • min_bid_price (Field16) — BIGINT — NULL
  • auction_date (Field17) — DATE — NULL
  • status (Field18) — VARCHAR(30) — NOT NULL
  • num_failures (Field19) — INT — NOT NULL
  • detail_url (Field20) — TEXT — NULL
  • created_at (Field21) — TIMESTAMP — NOT NULL
  • updated_at (Field22) — TIMESTAMP — NOT NULL

crawl_job_log (데이터 수집 기록)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — NOT NULL
  • source (Field) — VARCHAR(20) — NOT NULL
  • started_at (Field2) — TIMESTAMP — NOT NULL
  • finished_at (Field3) — TIMESTAMP — NOT NULL
  • status (Field4) — VARCHAR(30) — NOT NULL
  • new_items (Field5) — INT — NOT NULL
  • updated_items (Field6) — INT — NOT NULL
  • error_message (Field7) — TEXT — NULL

notification_log (알림 기록)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — NOT NULL
  • type (Field) — VARCHAR(30) — NOT NULL
  • channel (Field2) — VARCHAR(20) — NOT NULL
  • status (Field3) — VARCHAR(30) — NOT NULL
  • message_title (Field4) — VARCHAR(200) — NULL
  • message_body (Field5) — TEXT — NULL
  • error_message (Field6) — TEXT — NULL
  • created_at (Field7) — TIME STAMP — NOT NULL
  • sent_at (Field8) — TIME STAMP — NULL
  • id (Key2) — BIGSERIAL — Foreign key → user.id — NOT NULL — PK, NOT NULL
  • id (Key3) — BIGSERIAL — Foreign key → auction_item.id — NOT NULL — NOT NULL
  • id (Key4) — BIGSERIAL — Foreign key → alert_preference.id — NOT NULL — NOT NULL

telegram_profile (Untitled)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — PK, NOT NULL
  • chat_id (Field) — VARCHAR(64) — NOT NULL, UNIQUE
  • is_active (Field2) — BOOLEAN — NOT NULL
  • linked_at (Field3) — TIMESTAMP — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTAMP — NOT NULL
  • id (Key2) — BIGSERIAL — Foreign key → user.id — NOT NULL — PK, NOT NULL

user (유저)

  • id (Key) — BIGSERIAL — Primary key — NOT NULL — PK, NOT NULL
  • email (Field) — VARCHAR(255) — NOT NULL, UNIQUE
  • password (Field2) — VARCHAR(128) — NOT NULL
  • name (Field3) — VARCHAR(120) — NOT NULL
  • is_active (Field4) — BOOLEAN — NOT NULL
  • is_staff (Field5) — BOOLEAN — NOT NULL
  • is_superuser (Field6) — BOOLEAN — NOT NULL
  • last_login (Field7) — TIMESTAMP
  • date_joined (Field8) — TIMESTAMP