경매

테이블 (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