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 — 게시글