원자재플랫폼
테이블 (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