nfteam

Tables (13)

cart

  • cart_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • payment_yn — BOOLEAN
  • created_date — DATE
  • modified_date — DATE

cart_item_rel

  • rel_id — BIGINT — Primary key — NOT NULL
  • cart_id — BIGINT — Foreign key → cart.cart_id — NOT NULL
  • item_id — BIGINT — Foreign key → item.item_id — NOT NULL

coin

  • coin_id — BIGINT — Primary key — NOT NULL
  • coin_name — VARCHAR
  • withdraw_fee — DOUBLE
  • coin_image — VARCHAR
  • created_date — DATE
  • modified_date — DATE

coin_fee_history

  • coin_history_id — BIGINT — Primary key — NOT NULL
  • coin_name — VARCHAR
  • withdraw_fee — DOUBLE
  • created_date — DATE

coin_member_rel

  • rel_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • coin_id — BIGINT — Foreign key → coin.coin_id — NOT NULL
  • coin_count — DOUBLE
  • created_date — DATE
  • modified_date — DATE

coin_order

  • order_id — BIGINT — Primary key — NOT NULL
  • coin_id — BIGINT — Foreign key → coin.coin_id — NOT NULL
  • buyer_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • coin_count — DOUBLE
  • pay_tid — VARCHAR
  • total_price — DOUBLE
  • pay_status — BOOLEAN
  • created_date — DATE
  • modified_date — DATE

coin_rank

  • rank_id — BIGINT — Primary key — NOT NULL
  • rank_coin_id — BIGINT
  • rank_string — VARCHAR
  • created_date — DATE
  • modified_date — DATE

item

  • item_id — BIGINT — Primary key — NOT NULL
  • collection_id — BIGINT — Foreign key → item_collection.collection_id — NOT NULL
  • owner_member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • credential_id — BIGINT — Foreign key → item credential.credential_id — NOT NULL
  • item_name — VARCHAR
  • item_img_name — VARCHAR
  • on sale (on_sale) — BIT
  • item_desc — VARCHAR
  • item_price — DOUBLE
  • created_date — DATE
  • modified_date — DATE

item credential

  • credential_id — BIGINT — Primary key — NOT NULL
  • item_id — BIGINT — Foreign key → item.item_id — NOT NULL
  • item_code (item_cod) — VARCHAR
  • trans_encryption — VARCHAR

item_collection

  • collection_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • coin_id — BIGINT — Foreign key → coin.coin_id — NOT NULL
  • col_name — VARCHAR
  • col_desc — VARCHAR
  • logo_img_name — VARCHAR
  • banner_img_name — VARCHAR
  • created_date — DATE
  • modified_date — DATE

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR
  • password — VARCHAR
  • nickname — VARCHAR
  • profile_image_name — VARCHAR
  • banner_image_name — VARCHAR
  • member_desc — VARCHAR
  • last_login — DATE
  • member_platform — VARCHAR
  • member_role — VARCHAR
  • member_status — VARCHAR
  • created_date — DATE
  • modified_date — DATE

time_rank

  • rank_id — BIGINT — Primary key — NOT NULL
  • rank_time_criteria — VARCHAR
  • rank_string — VARCHAR
  • created_date — DATE
  • modified_date — DATE

transaction

  • trans_id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • buyer_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • coin_id — BIGINT — Foreign key → coin.coin_id — NOT NULL
  • collection_id — BIGINT — Foreign key → item_collection.collection_id — NOT NULL
  • item_id — BIGINT — Foreign key → item.item_id — NOT NULL
  • trans_price — DOUBLE
  • created_date — DATE
  • modified_date — DATE