1

Tables (22)

game

  • appid — VARCHAR2(30 BYTE) — 게임
  • name — VARCHAR2(200 BYTE)
  • developer — VARCHAR2(100 BYTE) — 게임
  • publisher — VARCHAR2(100 BYTE) — 게임
  • initialprice — NUMBER — 게임
  • finalprice — NUMBER — 게임
  • discountrate — NUMBER — 할인율
  • description — CLOB
  • platform — VARCHAR2(100 BYTE) — 게임
  • meta — NUMBER — 메타크리틱
  • category — VARCHAR2(1000 BYTE)
  • genre — VARCHAR2(1000 BYTE) — 게임
  • headerimg — VARCHAR2(1000 BYTE) — 게임
  • movie — VARCHAR2(1000 BYTE) — 게임
  • releasedate — VARCHAR2(50 BYTE) — 게임
  • achievement — VARCHAR2(2000 BYTE) — 게임
  • positive — NUMBER
  • ccu — NUMBER — 전일
  • short_description — VARCHAR2(4000 BYTE) — 게임
  • supported_languages — VARCHAR2(4000 BYTE) — 게임
  • pcminimum — VARCHAR2(2000 BYTE) — 게임
  • pcrecommended — VARCHAR2(2000 BYTE) — 게임

tb_board_gen

  • board_no — NUMBER — Primary key — NOT NULL — 게시글
  • board_title — VARCHAR2(50) — NOT NULL — 게시글
  • board_content — VARCHAR2(2000) — 게시글
  • board_date — DATE — NOT NULL — 게시글
  • board_count — NUMBER — 게시글
  • board_like — NUMBER — 게시글
  • board_orifile — VARCHAR2(500) — 게시글
  • board_refile — VARCHAR2(500) — 게시글
  • appid — VARCHAR2(30 BYTE) — NOT NULL — 게임
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자
  • board_notice — VARCHAR2(50) — 공지글

tb_board_like

  • board_no — NUMBER — Primary key — NOT NULL — 좋아요누른게시물
  • user_id — VARCHAR2(50 BYTE) — 좋아요누른회원
  • like_date — DATE — NOT NULL — 좋아요누른날짜

tb_board_tar

  • board_no — NUMBER — Primary key — NOT NULL — 게시글
  • board_title — VARCHAR2(50) — NOT NULL — 게시글
  • board_content — VARCHAR2(2000) — 게시글
  • board_date — DATE — NOT NULL — 게시글
  • board_count — NUMBER — 조회수
  • appid — VARCHAR2(30 BYTE) — NOT NULL
  • board_like — NUMBER — 좋아요
  • board_orifile — VARCHAR2(500) — 원본
  • board_refile — VARCHAR2(500) — 변환된
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 게시글
  • board_notice — VARCHAR2(50) — 공지글

tb_comment

  • com_no — NUMBER — Primary key — NOT NULL — 댓글
  • com_contents — VARCHAR2(500) — NOT NULL — 댓글
  • com_date — DATE — NOT NULL — 댓글
  • com_lev — NUMBER — NOT NULL — 댓글
  • com_no2 — NUMBER — 대댓글
  • board_no — NUMBER — NOT NULL — 게시글
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 작성자

tb_community

  • communityid — NUMBER — Primary key — NOT NULL — 밴드
  • communityname — VARCHAR2(100) — NOT NULL — 밴드
  • communitydate — DATE — 밴드
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 밴드
  • communityimgori — VARCHAR2(100) — 밴드
  • communityimgrename — VARCHAR2(100)
  • communitydesc — VARCHAR2(500) — 밴드
  • isdeleted — CHAR(1) — NOT NULL

tb_community_board

  • cboardno — NUMBER — Primary key — NOT NULL — 밴드게시글
  • cboardtitle — VARCHAR2(50) — NOT NULL — 밴드게시글
  • cboardcontent — VARCHAR2(2000) — 밴드게시글
  • cboarddate — DATE — NOT NULL — 밴드게시글
  • cboardlike — NUMBER — NOT NULL — 밴드게시글
  • cboardorifile — VARCHAR2(500) — 밴드게시글
  • cboardrefile — VARCHAR2(500) — 밴드게시글
  • cboardnotice — CHAR(5) — NOT NULL — 밴드게시글
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 밴드게시글
  • communityid — NUMBER — NOT NULL — 게시글이
  • isdeleted — CHAR(1) — NOT NULL

tb_community_comment

  • ccomno — NUMBER — Primary key — NOT NULL — 밴드
  • ccomcontent — VARCHAR2(500) — 밴드
  • ccomdate — DATE — 밴드
  • ccomlvl — NUMBER — NOT NULL — 밴드
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 밴드
  • cboardno — NUMBER — NOT NULL — 밴드게시글
  • communityid — NUMBER — NOT NULL
  • isdeleted — CHAR(1) — NOT NULL

tb_community_img

  • communityid — NUMBER — Primary key — NOT NULL
  • c_imgoriginal — VARCHAR2(100) — NOT NULL — 밴드
  • c_imgreplace — VARCHAR2(100) — NOT NULL — 밴드
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 이미지를

tb_community_like

  • communityid — NUMBER — Primary key — NOT NULL — 밴드
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자
  • cliked_day — DATE — 밴드

tb_community_member

  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 밴드
  • communityid — NUMBER — Foreign key → tb_community.communityid — NOT NULL — 밴드
  • member_roll — CHAR(1) — NOT NULL — 멤버
  • member_date — DATE — NOT NULL — 멤버
  • isdeleted — CHAR(1) — NOT NULL

tb_community_report

  • user_id — VARCHAR2(20) — Primary key — NOT NULL — 사용자
  • communityid — NUMBER — Primary key — NOT NULL — 커뮤니티번호
  • c_report_time — DATE — 커뮤니티신고
  • c_report_desc — VARCHAR2(500) — 커뮤니티신고
  • c_rep_type — VARCHAR2(50) — NOT NULL — 커뮤니티신고유형

tb_community_req

  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자
  • communityid — NUMBER — Foreign key → tb_community.communityid — NOT NULL — 밴드
  • requestdes — VARCHAR2(1000) — 밴드
  • requestdate — DATE — 밴드

tb_community_sch

  • schid — NUMBER — Primary key — NOT NULL — 밴드
  • schname — VARCHAR2(100) — NOT NULL — 밴드
  • schdes — VARCHAR2(500) — 밴드
  • communityid — NUMBER — NOT NULL
  • schstart — DATE — 밴드
  • schend — DATE — 밴드

tb_community_vote

  • schid — NUMBER — Foreign key → tb_community_sch.schid — NOT NULL — 밴드
  • votepart — VARCHAR2(50) — NOT NULL — 밴드
  • votedate — DATE — 일정
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 밴드투표자

tb_genboard_like

  • board_no — NUMBER — Primary key — NOT NULL — 좋아요누른게시물
  • user_id — VARCHAR2(50 BYTE) — 좋아요누른회원
  • like_date — DATE — NOT NULL — 좋아요누른날짜

tb_grade

  • grade — NUMBER — Primary key — NOT NULL — 등급
  • grade_mean — VARCHAR2(100) — NOT NULL — 등급
  • min_point — NUMBER — NOT NULL — 최소
  • max_point — NUMBER — NOT NULL — 최대

tb_hotlist

  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자
  • appid — VARCHAR2(30) — Foreign key → game.appid — NOT NULL — 좋아요누른
  • favo_id — VARCHAR2(30) — NOT NULL — 좋아요
  • like_dt — VARCHAR2(30) — NOT NULL — 좋아요누른날짜

tb_record

  • login_date — DATE — Primary key — NOT NULL — 로그인
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자

tb_report

  • board_no — VARCHAR2(300) — Primary key — NOT NULL — 신고한
  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 신고한
  • report_res — NUMBER — NOT NULL — 신고
  • report_date — DATE — NOT NULL — 신고
  • user_id2 — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 게시글

tb_user

  • user_id — VARCHAR2(50) — Primary key — NOT NULL — 회원아이디
  • admin_id — VARCHAR2(20) — NOT NULL — 관리자아이디
  • user_pwd — VARCHAR2(100) — NOT NULL — 회원비밀번호
  • user_nickname — VARCHAR2(30) — NOT NULL — 회원닉네임
  • user_name — VARCHAR2(100) — NOT NULL — 회원이름
  • user_phone — VARCHAR2(13) — NOT NULL — 회원전화번호
  • user_email — VARCHAR2(100) — NOT NULL — 회원이메일
  • user_birth — DATE — 회원생일
  • user_level — VARCHAR2(20) — NOT NULL — 회원등급
  • user_status — VARCHAR2(30) — NOT NULL — 회원
  • ban_release_date — DATE — 정지
  • user_point — NUMBER — NOT NULL — 보유포인트
  • user_enrolldate — DATE
  • user_access — DATE — 접속기록
  • user_original_profile — VARCHAR2(30) — 프로필이미지
  • confirm_answer — VARCHAR2(100) — 본인확인용

tb_user_like

  • user_id — VARCHAR2(20) — Foreign key → tb_user.user_id — NOT NULL — 사용자
  • board_click_day — DATE — NOT NULL — 게시글