원자재플랫폼

테이블 (9)

commodity

  • commodity_id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • unit — VARCHAR(20) — NOT NULL
  • description — TEXT
  • storage_condition — VARCHAR(255)
  • created_at — TIMESTAMP

company_profile

  • company_id — BIGSERIAL
  • member_id — BIGINT — NOT NULL
  • business_number — VARCHAR(50) — NOT NULL
  • representative_name — VARCHAR(100)
  • industry — VARCHAR(100)
  • address — VARCHAR(255)

group_purchase

  • purchase_id — BIGSERIAL
  • commodity_id — BIGINT — NOT NULL
  • target_amount — NUMERIC(18,2) — NOT NULL
  • unit_price — NUMERIC(18,2) — NOT NULL
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • status — VARCHAR(20)

logistics_booking

  • booking_id — BIGSERIAL
  • member_id — BIGINT — NOT NULL
  • commodity_id — BIGINT — NOT NULL
  • amount — NUMERIC(18,2) — NOT NULL
  • source_location — VARCHAR(255)
  • destination_location — VARCHAR(255)
  • status — VARCHAR(20)
  • booked_at — TIMESTAMP

member

  • member_id — BIGSERIAL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • member_type — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

ownership_share

  • share_id — BIGSERIAL
  • member_id — BIGINT — NOT NULL
  • commodity_id — BIGINT — NOT NULL
  • amount — NUMERIC(18,2) — NOT NULL
  • acquired_at — TIMESTAMP

purchase_participation

  • participation_id — BIGSERIAL
  • purchase_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • amount — NUMERIC(18,2) — NOT NULL
  • paid_amount — NUMERIC(18,2) — NOT NULL
  • created_at — TIMESTAMP

share_trade

  • trade_id — BIGSERIAL
  • seller_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • share_id — BIGINT — NOT NULL
  • trade_amount — NUMERIC(18,2) — NOT NULL
  • price — NUMERIC(18,2) — NOT NULL
  • traded_at — TIMESTAMP

warehouse

  • warehouse_id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • capacity — NUMERIC(18,2)
  • storage_fee_rate — NUMERIC(18,2)
  • created_at — TIMESTAMP