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)