rabs
Tables (7)
consent
- member_id — VARCHAR2(20) — Foreign key → member.member_id — NOT NULL
- page_num — NUMBER — Foreign key → consent_form.page_num — NOT NULL
- is_check — boolean
- view_date — date
- expiration_date — date
consent_form
- page_num — NUMBER — Primary key — NOT NULL
- url — VARCHAR2(150)
- type — VARCHAR2(10)
game_product (게임 상품)
- game_id — BIGINT — Primary key — NOT NULL
- game_name — VARCHAR2(120)
- game_name_kr — VARCHAR2(120)
- release_date — DATE
- price — INT
game_review (게임 리뷰)
- review_id — BIGINT — Primary key — NOT NULL
- game_id — BIGINT — Foreign key → game_product.game_id — NOT NULL
- user_id — VARCHAR2(20) — Foreign key → user.user_id — NOT NULL
- review_title — VARCHAR2(200)
- review_content — VARCHAR2(5000)
- create_date — DATE
- modify_date — DATE
- review_score — INT
member
- member_id — VARCHAR2(20) — Primary key — NOT NULL
- member_pw — VARCHAR2(20)
- member_name — VARCHAR2(10)
- member_nickname — VARCHAR2(10)
- member_mail — VARCHAR2(50)
- member_phone_number — VARCHAR2(11)
order_history (주문내역)
- history_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR2(20) — Foreign key → user.user_id — NOT NULL
- game_id — BIGINT — Foreign key → game_product.game_id — NOT NULL
- user_work_date — DATE
- order_count — INT
- price — INT
user (회원)
- user_id — VARCHAR2(20) — Primary key — NOT NULL
- nickname — VARCHAR2(20)
- email — VARCHAR2(20)
- password — VARCHAR2(20)