tetsErd
Tables (14)
answer
- deleted — boolean — NOT NULL
- answer_id — bigint
- created_at — timestamp(6)
- question_id — bigint
- updated_at — timestamp(6)
- content — varchar(255)
- title — varchar(255)
auction
- auction_id — bigint
- bid_count — bigint
- bid_unit — bigint
- created_at — timestamp(6)
- end_date — timestamp(6)
- instant_buy_price — bigint
- like_count — bigint — NOT NULL
- member_id — bigint
- now_price — bigint
- start_date — timestamp(6)
- start_price — bigint
- updated_at — timestamp(6)
- auction_status — varchar(255)
- BIDDING::character — varying
- NO_BIDS::character — varying
- CONCLUDED::character — varying
- COMPLETED::character — varying)::text))
- content — text
- thumbnail_path — varchar(255)
- title — varchar(255)
- category_id — bigint — NOT NULL
bid
- auction_id — bigint
- bid_id — bigint
- bid_price — bigint
- buyer_member_id — bigint
- created_at — timestamp(6)
- updated_at — timestamp(6)
category
- category_id — bigint
- parent_id — bigint
- name — varchar(255)
- order_index — integer
chat
- chat_id — bigint
- created_at — timestamp(6)
- room_id — bigint
- sender_member_id — bigint
- updated_at — timestamp(6)
- message — varchar(255)
- message_type — varchar(255)
- CHAT::character — varying
- LEAVE::character — varying)::text))
chatroom
- auction_id — bigint
- buyer_member_id — bigint
- created_at — timestamp(6)
- room_id — bigint
- seller_member_id — bigint
- updated_at — timestamp(6)
- room_name — varchar(255)
conclude
- auction_id — bigint
- buyer_member_id — bigint
- conclude_id — bigint
- conclude_price — bigint
- concluded_at — timestamp(6)
flyway_schema_history
- installed_rank — integer — NOT NULL
- version — varchar(50)
- description — varchar(200) — NOT NULL
- type — varchar(20) — NOT NULL
- script — varchar(1000) — NOT NULL
- checksum — integer
- installed_by — varchar(100) — NOT NULL
- installed_on — timestamp — NOT NULL
- execution_time — integer — NOT NULL
- success — boolean — NOT NULL
image
- auction_id — bigint
- image_id — bigint
- file_name — varchar(255)
- image_path — varchar(255)
likes
- auction_id — bigint
- created_at — timestamp(6)
- likes_id — bigint
- member_id — bigint
member
- average_rating — double
- created_at — timestamp(6)
- member_id — bigint
- updated_at — timestamp(6)
- birth — date
- email — varchar(255)
- member_status — varchar(255)
- DEACTIVATE::character — varying)::text))
- nickname — varchar(255)
- password — varchar(255)
- phone_number — varchar(255)
- profile_image_url — varchar(255)
- provider — varchar(255)
- provider_id — varchar(255)
- role — varchar(255)
- ROLE_USER::character — varying)::text))
- username — varchar(255)
- email_verified — boolean
notification
- notification_id — bigserial
- member_id — bigint
- event_name — varchar(255) — NOT NULL
- notification_code — varchar(255) — NOT NULL
- data — text — NOT NULL
- read — boolean — NOT NULL
- created_at — timestamp
- updated_at — timestamp
question
- deleted — boolean — NOT NULL
- auction_id — bigint — NOT NULL
- created_at — timestamp(6)
- member_id — bigint — NOT NULL
- question_id — bigint
- updated_at — timestamp(6)
- content — varchar(255)
- title — varchar(255)
review
- rating — double
- auction_id — bigint
- created_at — timestamp(6)
- recipient_member_id — bigint
- review_id — bigint
- reviewer_member_id — bigint
- updated_at — timestamp(6)
- content — varchar(255)
- review_type — varchar(255)
- BUY_REVIEW::character — varying)::text))