겜도리

테이블 (6)

gemdori_game_tbl

  • game_code — VARCHAR2(8)
  • game_title — VARCHAR2(100)
  • game_contents — CLOB
  • game_publisher — VARCHAR2(100)
  • publishing_date — DATE
  • game_price — NUMBER
  • game_genre — VARCHAR2(45)
  • game_category — VARCHAR2(60)
  • game_tag — VARCHAR2(30)
  • game_main_image — VARCHAR2(120)
  • ingame_images — VARCHAR2(1500)
  • game_sys_req — VARCHAR2(800)

gemdori_purchase_history_table

  • purchase_code — VARCHAR2(8)
  • user_code — VARCHAR2(8)
  • game_code — VARCHAR2(8)
  • recipient_code — VARCHAR2(8)
  • purchase_date — VARCHAR2(50)
  • price — NUMBER
  • discount_rate — NUMBER
  • payment_method — VARCHAR2(50)
  • purchase_status — NUMBER(1)

gemdori_review_tbl

  • review_code — NUMBER
  • user_code — VARCHAR2(8)
  • review_contents — VARCHAR2(1500)
  • rating — NUMBER
  • write_date — DATE
  • game_code — VARCHAR2(8)

gemdori_user_profile_tbl

  • user_code — VARCHAR2(8)
  • user_first_name — VARCHAR2(20)
  • user_last_name — VARCHAR2(20)
  • user_name — VARCHAR2(50)
  • user_email — VARCHAR2(100)
  • user_phone — VARCHAR2(20)
  • user_birthday — DATE
  • user_gender — CHAR(1)
  • user_intro — VARCHAR2(200)
  • user_image — VARCHAR2(100)
  • update_time — DATE

gemdori_user_security_tbl

  • user_code — VARCHAR2(8)
  • login_fail_count — NUMBER
  • last_login_date — DATE
  • is_locked — NUMBER(1)
  • update_time — DATE

gemdori_user_sign_tbl

  • user_code — VARCHAR2(8)
  • user_id — VARCHAR2(50)
  • user_pw — VARCHAR2(100)
  • user_status — NUMBER(1)
  • create_time — DATE
  • delete_time — DATE