1
Tables (16)
BOARD
- SEQ — NUMBER(5,0) — Primary key
- TITLE — VARCHAR2(200 BYTE)
- WRITER — VARCHAR2(20 BYTE)
- CONTENT — VARCHAR2(2000 BYTE)
- CATEGORY — VARCHAR2(20 BYTE)
- IMAGE — VARCHAR2(250 BYTE)
- REGDATE — DATE
- VIEWCNT — NUMBER(5,0)
- RECOMMANDCNT — NUMBER(5,0)
CART
- SEQ — NUMBER(5,0) — Primary key
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → GAME.SEQ
- USERID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.USERID
- QUANTITY — NUMBER(3,0)
- INDATE — DATE
DESCIMG
- SEQ — NUMBER(5,0) — Foreign key → GAME.SEQ
- IMGPATH — VARCHAR2(250 BYTE)
GAME
- SEQ — NUMBER(5,0) — Primary key
- NAME — VARCHAR2(20 BYTE)
- IMAGE — VARCHAR2(250 BYTE)
- COSTPRICE — NUMBER(30,0)
- SALESPRICE — NUMBER(30,0)
- PROFIT — NUMBER(30,0)
- DISCOUNT — NUMBER(30,0)
- CONTENT — VARCHAR2(1000 BYTE)
- STOCK — NUMBER(10,0)
- MINPLAYER — NUMBER(3,0)
- MAXPLAYER — NUMBER(3,0)
- PLAYTIME — NUMBER(10,0)
GAMETAGCON
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → GAME.SEQ
- TAGSEQ — NUMBER(5,0) — Foreign key → TAG.TAGSEQ
MEMBER
- USERID — VARCHAR2(20 BYTE) — Primary key
- PWD — VARCHAR2(20 BYTE)
- NAME — VARCHAR2(20 BYTE)
- NICKNAME — VARCHAR2(20 BYTE)
- EMAIL — VARCHAR2(30 BYTE)
- ADDRESS — VARCHAR2(100 BYTE)
- ZIPNUM — VARCHAR2(7 BYTE)
- PROFILE — VARCHAR2(250 BYTE)
- PHONE — VARCHAR2(20 BYTE)
- MEMBERSHIP — NUMBER(10,0)
- INDATE — DATE
- ROLE — VARCHAR2(1 BYTE)
MEMBERTAGCON
- USERID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.USERID
- TAGSEQ — NUMBER(5,0) — Foreign key → TAG.TAGSEQ
NOTICE
- SEQ — NUMBER(5,0) — Primary key
- TITLE — VARCHAR2(200 BYTE)
- WRITER — VARCHAR2(20 BYTE)
- CONTENT — VARCHAR2(2000 BYTE)
- IMAGE — VARCHAR2(250 BYTE)
- REGDATE — DATE
- VIEWCNT — NUMBER(5,0)
ORDERDETAIL
- SEQ — NUMBER(5,0) — Primary key
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → ORDERS.SEQ
- SEQ (SEQ3) — NUMBER(5,0) — Foreign key → GAME.SEQ
- QUANTITY — NUMBER(3,0)
- RESULT — VARCHAR2(1 BYTE)
ORDERS
- SEQ — NUMBER(5,0) — Primary key
- INDATE — DATE
- USERID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.USERID
QNA
- SEQ — NUMBER(5,0) — Primary key
- TITLE — VARCHAR2(200 BYTE)
- CONTENT — VARCHAR2(2000 BYTE)
- REPLY — VARCHAR2(2000 BYTE)
- WRITER — VARCHAR2(20 BYTE)
- STATE — CHAR(1 BYTE)
- INDATE — DATE
RATING
- SEQ — NUMBER(5,0) — Primary key
- USERID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.USERID
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → GAME.SEQ
- RATING — NUMBER(1,0)
REPLY
- SEQ — NUMBER(5,0) — Primary key
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → BOARD.SEQ
- WRITER — VARCHAR2(20 BYTE)
- CONTENT — VARCHAR2(1000 BYTE)
- IMAGE — VARCHAR2(250 BYTE)
- REGDATE — DATE
REVIEWCON
- SEQ — NUMBER(5,0) — Primary key
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → BOARD.SEQ
- SEQ (SEQ3) — NUMBER(5,0) — Foreign key → GAME.SEQ
TAG
- TAGSEQ — NUMBER(5,0) — Primary key
- CATEGORY — VARCHAR2(20 BYTE)
- TAGNAME — VARCHAR2(100 BYTE)
WISHLIST
- SEQ — NUMBER(5,0) — Primary key
- USERID — VARCHAR2(20 BYTE) — Foreign key → MEMBER.USERID
- SEQ (SEQ2) — NUMBER(5,0) — Foreign key → GAME.SEQ