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