겜도리
테이블 (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