TRADEUP

Tables (22)

CATEGORY (Untitled4)

  • category_idx (Key) — INT — Primary key — NOT NULL
  • category_name (Field) — VARCHAR(100)

CHAT_MESSAGE (Untitled16)

  • room_id (Key) — VARCHAR(50) — Foreign key → CHAT_ROOM_LIST.room_id — NOT NULL
  • sender_id (Field) — VARCHAR(16)
  • receiver_id (Field2) — VARCHAR(16)
  • message (Field3) — TEXT
  • type (Field4) — VARCHAR(10)
  • message_target (Field5) — VARCHAR(11)
  • send_time (Field6) — DATETIME

CHAT_ROOM_LIST (Untitled15)

  • room_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • user_id (Field) — VARCHAR(16)
  • status (Field2) — VARCHAR(16)

COMMITION_ACCOUNT (Untitled19)

  • account_idx (Key) — INT — Primary key — NOT NULL
  • owner_bank (Field) — VARCHAR(30)
  • owner_acc (Field2) — VARCHAR(20)
  • commissions (Field4) — VARCHAR(20)

DEPOSIT (Untitled20)

  • deposit_idx (Key) — INT — Primary key — NOT NULL
  • deposit_bank (Field) — VARCHAR(30)
  • deposit_acc (Field2) — VARCHAR(20)
  • owner_bank (Field3) — VARCHAR(30)
  • owner_acc (Field4) — VARCHAR(20)
  • product_price (Field5) — VARCHAR(10)
  • member_id (Field6) — VARCHAR(15)
  • member_name (Field7) — VARCHAR(10)
  • deposit_date (Field8) — DATETIME
  • product_num (Field9) — INT
  • merchant_uid (Field10) — VARCHAR(30)

EXITED_FEEDBACK (Untitled18)

  • exid_feedback_idx (Key) — INT — Primary key — NOT NULL
  • exid_feedback (Field) — TEXT
  • exid_feedback_tip (Field2) — TEXT

FAVORITE (Untitled3)

  • favorite_idx (Key) — INT — Primary key — NOT NULL
  • member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • product_num (Key2) — INT — Foreign key → PRODUCT.product_num — NOT NULL

FINTECH_USER_INFO (Untitled7)

  • member_id (Key2) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • access_token (Field) — VARCHAR(500)
  • user_seq_no (Field2) — VARCHAR(10)
  • Field3

MEMBER (Untitled)

  • member_num (Key) — INT — Primary key — NOT NULL
  • member_id (Key2) — VARCHAR(15) — Primary key — NOT NULL
  • member_name — VARCHAR(15)
  • member_nick_name (Field) — VARCHAR(100)
  • member_passwd (Field3) — VARCHAR(100)
  • member_e_mail (Field4) — VARCHAR(100)
  • member_e_mail1 (Field5) — VARCHAR(100)
  • member_e_mail2 (Field6) — VARCHAR(100)
  • member_insert_date (Field7) — DATETIME
  • member_phone_num (Field8) — VARCHAR(100)
  • member_birth (Field9) — VARCHAR(100)
  • kakao_id (Field10) — VARCHAR(100)
  • naver_id (Field11) — VARCHAR(100)
  • member_state (Field12) — VARCHAR(100)
  • exid_date (Field13) — DATETIME
  • exid_feedback_idx (Field14) — INT
  • exid_etc_feedack (Field15) — TEXT
  • member_profile_img (Field16) — TEXT

MY_ACCOUNT (Untitled6)

  • account_idx (Key) — INT — Primary key — NOT NULL
  • member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • account_num (Field) — VARCHAR(100)
  • account_bank (Field2) — VARACHAR(20)
  • account_main (Field3) — TINYINT
  • account_holder_name (Field4) — VARCHAR(15)

MY_ADDRESS (Untitled10)

  • address_idx (Key) — INT — Primary key — NOT NULL
  • member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • recipient_name (Field) — VARCHAR(10)
  • recipient_phone_num (Field2) — VARCHAR(20)
  • address1 (Field3) — VARCHAR(100)
  • address2 (Field4) — VARCHAR(100)
  • address_name (Field5) — VARCHAR(20)
  • address_main (Field6) — TINYINT(1)
  • postcode (Field7) — VARCHAR(10)

OFTEN_QUESTION (Untitled17)

  • often_qna_num (Key) — INT — Primary key — NOT NULL
  • qna_content (Field) — TEXT
  • qna_answer (Field2) — TEXT
  • qna_filter (Field3) — VARCHAR(3)

PRODUCT (Untitled2)

  • product_num (Key) — INT — Primary key — NOT NULL
  • member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • category_idx (Key3) — INT — Foreign key → CATEGORY.category_idx — NOT NULL
  • product_name (Field) — VARCHAR(100)
  • product_price (Field2) — VARCHAR(15)
  • product_info (Field3) — TEXT
  • product_release (Field4) — DATETIME
  • product_main_img (Field5) — VARCHAR(10)
  • Trading_method (Field6) — VARCHAR(10)
  • product_status (Field7) — VARCHAR(10)
  • delivery_method (Field8)

PRODUCT_IMG (Untitled5)

  • product_image_num (Key) — INT — Primary key — NOT NULL
  • product_num (Key2) — INT — Foreign key → PRODUCT.product_num — NOT NULL
  • product_image (Field) — TEXT

QUESTION (Untitled11)

  • qna_num (Key) — INT — Primary key — NOT NULL
  • member_id (Key22) — VARCHAR(15) — Foreign key → MEMBER.member_id — NOT NULL
  • qna_category_detail_num (Key2) — INT — Foreign key → QUESTION_CATEGORY_DETAIL.qna_category_detail_num — NOT NULL
  • qna_content (Field) — TEXT
  • qna_answer (Field2) — TEXT
  • qna_is_answer (Field3) — VARCHAR(2)
  • qna_date (Field4) — VARCHAR(30)

QUESTION_CATEGORY (Untitled14)

  • qna_category_num (Key) — INT — Primary key — NOT NULL
  • qna_category_name (Field) — VARCHAR(100)

QUESTION_CATEGORY_DETAIL (Untitled12)

  • qna_category_detail_num (Key) — INT — Primary key — NOT NULL
  • qna_category_num (Key2) — INT — Foreign key → QUESTION_CATEGORY.qna_category_num — NOT NULL
  • qna_category_detail_name (Field) — VARCHAR(100)

QUESTION_IMG (Untitled13)

  • qna_num (Key) — INT — Foreign key → QUESTION.qna_num — NOT NULL
  • qna_image_name (Field) — VARCHAR(100)
  • qna_image_real_file (Field2) — VARCHAR(100)

REPORT (Untitled8)

  • report_idx (Key) — INT — Primary key — NOT NULL
  • report_member_num (Key2) — INT — Foreign key → MEMBER.member_num — NOT NULL
  • report_product_num (Key3) — INT — Foreign key → PRODUCT.product_num — NOT NULL
  • report_content (Field) — TEXT
  • qna_category_detail_num (Field2) — INT
  • report_date (Field3) — TEXT
  • report_processing_date (Field4) — TEXT
  • report_is_accept (Field5) — VARCHAR(3)

REPORT_IMG (Untitled9)

  • report_idx (Key) — INT — Foreign key → REPORT.report_idx — NOT NULL
  • report_image_name (Field) — TEXT
  • report_image_real_file (Field2) — TEXT

UPPAY (Untitled22)

  • uppay_idx (Key) — INT — Primary key — NOT NULL
  • member_id (Field) — VARCHAR(15)
  • uppay_pay (Field2) — VARCHAR(10)
  • uppay_use (Field3) — VARCHAR(50)
  • uppay_date (Field4) — DATETIME
  • uppay_remain (Field5) — VARCHAR(10)

WITHDRAW (Untitled21)

  • withdraw_idx (Key) — INT — Primary key — NOT NULL
  • owner_bank (Field) — VARCHAR(30)
  • owner_acc (Field2) — VARCHAR(20)
  • withdraw_bank (Field3) — VARCHAR(30)
  • withdraw_acc (Field4) — VARCHAR(20)
  • commission (Field5) — VARCHAR(10)
  • product_price (Field6) — VARCHAR(10)
  • member_id (Field7) — VARCHAR(15)
  • member_name (Field8) — VARCHAR(10)
  • method (Field9) — VARCHAR(20)
  • buy_check (Field10) — VARCHAR(10)
  • withdraw_date (Field11) — DATETIME
  • product_num (Field12) — INT
  • merchant_uid (Field13) — VARCHAR(30)