나라장터
테이블 (5)
bids
- id — int — 기본 키 — NOT NULL
- announcement_type — varchar(255) — NOT NULL
- announcement_date — varchar(255) — NOT NULL
- prespec_num — varchar(255)
- bid_num — varchar(255) — NOT NULL
- reference_num — varchar(255) — NOT NULL
- announcement_name — varchar(255) — NOT NULL
- announcement_agency — varchar(255) — NOT NULL
- demand_agency — varchar(255) — NOT NULL
- contract_method — varchar(255) — NOT NULL
- bid_method — varchar(255) — NOT NULL
- winning_bid — varchar(255) — NOT NULL
- budget — varchar(255) — NOT NULL
- file — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- prespec_id — int — 외래 키 → pre_specs.id
- INDEX — `prespec_num_idx`
bookmarks
- id — int — 기본 키 — NOT NULL
- user_id (userId) — int — 외래 키 → users.id — NOT NULL
- order_id (orderId) — int — 외래 키 → orders.id
- prespec_id (prespecId) — int — 외래 키 → pre_specs.id
- bid_id (bidId) — int — 외래 키 → bids.id
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
orders
- id — int — 기본 키 — NOT NULL
- business_category — varchar(255) — NOT NULL
- order_plan_num — varchar(255) — NOT NULL
- publication_date — varchar(255) — NOT NULL
- ordering_agency — varchar(255) — NOT NULL
- order_date — varchar(255) — NOT NULL
- procurement_method — varchar(255) — NOT NULL
- contract_method — varchar(255) — NOT NULL
- product_name_num — varchar(255) — NOT NULL
- product_name — varchar(255) — NOT NULL
- business_name — varchar(255) — NOT NULL
- department_name — varchar(255) — NOT NULL
- manager — varchar(255) — NOT NULL
- tell — varchar(255) — NOT NULL
- expected_purchase_amount — varchar(255) — NOT NULL
- budget — varchar(255) — NOT NULL
- file — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
pre_specs
- id — int — 기본 키 — NOT NULL
- pre_spec_num — varchar(255) — NOT NULL
- order_plan_num — varchar(255)
- business_category — varchar(255) — NOT NULL
- pre_spec_name — varchar(255) — NOT NULL
- demand_agency — varchar(255) — NOT NULL
- announcement_agency — varchar(255) — NOT NULL
- budget — varchar(255) — NOT NULL
- opinion_submission_deadline — varchar(255) — NOT NULL
- delivery_deadline — varchar(255) — NOT NULL
- pre_spec_publication_datetime — varchar(255) — NOT NULL
- specification_opinions — int — NOT NULL
- file — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- order_id — int — 외래 키 → orders.id
users
- id — int — 기본 키 — NOT NULL
- username — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL