최애의포토

테이블 (11)

card_creation_log

  • card_creation_log_id — BIGSERIAL
  • user_idID — BIGINT — NOT NULL
  • photo_card_id — BIGINT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

exchange_offer

  • exchange_offer_id — BIGSERIAL
  • listing_id — BIGINT — NOT NULL
  • seller_user_id — BIGINT — NOT NULL
  • offer_user_id — BIGINT — NOT NULL
  • requested_photo_card_id — BIGINT — NOT NULL
  • offered_photo_card_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP

listing

  • listing_id — BIGSERIAL
  • seller_user_id — BIGINT — NOT NULL
  • photo_card_id — BIGINT — NOT NULL
  • sale_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • quantity — INT — NOT NULL
  • price_per_unit — INT
  • desired_grade — VARCHAR(20)
  • desired_genre — VARCHAR(20)
  • 기타 — ))
  • desired_desc — TEXT
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP

notification

  • notification_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • CARD_SOLD_OUT — ))
  • entity_type — VARCHAR(20)
  • entity_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

oauth_account

  • oauth_account_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

photo_card

  • photo_card_id — BIGSERIAL
  • creator_user_id — BIGINT — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • description — TEXT
  • genre — VARCHAR(20) — NOT NULL
  • 기타 — ))
  • grade — VARCHAR(20) — NOT NULL
  • legendary — ))
  • min_price — INT — NOT NULL
  • total_supply — INT — NOT NULL
  • image_url — TEXT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP

point_box_draw

  • point_box_draw_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • earned_points — INT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

purchase

  • purchase_id — BIGSERIAL
  • listing_id — BIGINT — NOT NULL
  • buyer_user_id — BIGINT — NOT NULL
  • seller_user_id — BIGINT — NOT NULL
  • photo_card_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • total_price — INT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

refresh_token

  • refresh_token_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • reg_date — TIMESTAMP — NOT NULL

user_card

  • user_card_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • photo_card_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP

users

  • user_id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255)
  • points — INT — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • upt_date — TIMESTAMP