최애의포토
테이블 (8)
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
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
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