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