최애의포토

테이블 (11)

card_creation_log

  • card_creation_log_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • photo_card_id — BIGINT — NOT NULL
  • reg_date — DATETIME — NOT NULL

exchange_offer

  • exchange_offer_id — BIGINT
  • 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 — DATETIME — NOT NULL
  • upt_date — DATETIME

listing

  • listing_id — BIGINT
  • 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 — DATETIME — NOT NULL
  • upt_date — DATETIME

notification

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

oauth_account

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

photo_card

  • photo_card_id — BIGINT
  • creator_user_id — BIGINT — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • description — TEXT
  • genre — VARCHAR(20) — NOT NULL
  • grade — VARCHAR(20) — NOT NULL
  • min_price — INT — NOT NULL
  • total_supply — INT — NOT NULL
  • image_url — TEXT — NOT NULL
  • reg_date — DATETIME — NOT NULL
  • upt_date — DATETIME

point_box_draw

  • point_box_draw_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • earned_points — INT — NOT NULL
  • reg_date — DATETIME — NOT NULL

purchase

  • purchase_id — BIGINT
  • 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 — DATETIME — NOT NULL

refresh_token

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

user_card

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

users

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