경매
테이블 (10)
Address
- address_code — varchar(5) — 기본 키 — NOT NULL
- state_name — varchar(16) — NOT NULL
- city_name — varchar(32) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
AftBidding (successed_bidding)
- successed_bidding_id (id) — bigint — 기본 키 — NOT NULL
- bidding_id — bigint — 외래 키 → Bidding.bidding_id — NOT NULL
- decide_date — timestamp — NOT NULL
- bidding_result — varchar(11) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Auction_failed_log
- action_failed_log_id (id) — bigint — 기본 키 — NOT NULL
- auction_item_id — bigint — 외래 키 → Auction_items.auction_item_id — NOT NULL
- auction_start_date — datetime — NOT NULL
- auction_end_date — datetime — NOT NULL
- appraised_value — bigint — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Auction_items
- auction_item_id (id) — bigint — 기본 키 — NOT NULL
- address_code — varchar(5) — 외래 키 → Address.address_code — NOT NULL
- manager_id — varchar(25) — 외래 키 → Managers.manager_id — NOT NULL
- auction_item_name — varchar(100) — NOT NULL
- location — varchar(10) — NOT NULL
- lot_number — varchar(8) — NOT NULL
- address_detail — varchar(100) — NOT NULL
- appraised_value — bigint
- auction_start_date — datetime — NOT NULL
- auction_end_date — datetime — NOT NULL
- item_category — varchar(10) — NOT NULL
- area_size — decimal — NOT NULL
- auction_failed_count — int — NOT NULL
- hit — int — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Bidding
- bidding_id (id) — bigint — 기본 키 — NOT NULL
- id (user_id) — bigint — 외래 키 → User.id — NOT NULL
- auction_item_id — bigint — 외래 키 → Auction_items.auction_item_id — NOT NULL
- bidding_date — timestamp — NOT NULL
- amount — bigint — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Bookmark
- id (user_id) — varchar(20) — 외래 키 → User.id — NOT NULL
- auction_item_id — bigint — 외래 키 → Auction_items.auction_item_id — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Managers (Untitled3)
- manager_id (id) — varchar(25) — 기본 키 — NOT NULL
- password — varchar(150) — NOT NULL
- sort — varchar(150) — NOT NULL
- manager_name — varchar(20) — NOT NULL
- email — varchar(123) — NOT NULL
- phone_number (pheon_number) — varchar(13) — NOT NULL
- age — int — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
Notice
- notice_id (id) — bigint — 기본 키 — NOT NULL
- manager_id — varchar(25) — 외래 키 → Managers.manager_id — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(3000) — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
User
- id — varchar(20) — 기본 키 — NOT NULL
- password — varchar(200) — NOT NULL
- age — int — NOT NULL
- salt — varchar(200) — NOT NULL
- nickname — varchar(10) — NOT NULL
- email — varchar(123) — NOT NULL
- phone_number — varchar(13) — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
comment
- id — bigint — 기본 키 — NOT NULL
- id (user_id) — varchar(20) — 외래 키 → User.id — NOT NULL
- auction_item_id — bigint — 외래 키 → Auction_items.auction_item_id — NOT NULL
- content — varchar(300) — NOT NULL
- state — varchar(1) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp