Web_Game_Community
Tables (11)
Board
- BoardID (BOARD_SEQ) — NUMBER — Primary key — NOT NULL
- UserName (NICKNAME) — VARCHAR2(30)
- BoardTitle (TITLE) — VARCHAR2(300)
- Content (CONTENT) — VARCHAR2(4000)
- Write_Date (WRITE_DATE) — TIMESTAMP
- VIew_Count (VIEW_COUNT) — NUMBER
- Thumbs_Up (THUMBS_UP) — NUMBER
- DeleteYN (DELETE_YN) — CHAR(1)
- DeleteDate (DELETE_DATE) — TIMESTAMP
- Game_ID (GAME_ID) — NUMBER
FAQ
- FAQ_ID (FAQ_SEQ) — NUMBER — Primary key — NOT NULL
- UserName (NICKNAME) — VARCHAR2(30)
- FAQTitle (TITLE) — VARCHAR2(300)
- FAQContent (CONTENT) — VARCHAR2(4000)
- Write_Date (WRITE_DATE) — TIMESTAMP
- View_Count (VIEW_COUNT) — NUMBER
- Thumbs_Up (THUMBS_UP) — NUMBER
FILE (File)
- File_ID (FILE_SEQ) — NUMBER — Primary key — NOT NULL
- FileName (ORINAME) — VARCHAR2(300)
- SystemName (SYSNAME) — VARCHAR2(300)
- BoardID (PARENT_SEQ) — NUMBER
Game
- Game_ID (GAME_ID) — NUMBER — Primary key — NOT NULL
- Game_Name (GAME_NAME) — VARCHAR2(30)
GameLog
- Log_ID (LOG_SEQ) — NUMBER — Primary key — NOT NULL
- UserID (USERID) — NUMBER
- Game_ID (GAME_ID) — NUMBER
- Start_Time (START_TIME) — TIMESTAMP
- End_Time (END_TIME) — TIMESTAMP
Member
- UserID (ID) — VARCHAR2(30) — Primary key — NOT NULL
- UserName (NICKNAME) — VARCHAR2(30)
- UserPW (PW) — VARCHAR2(128)
- UserPhoneNum (PHONE) — VARCHAR2(20)
- Registration_Num (REG_NUM) — VARCHAR(14)
- Email (EMAIL) — VARCHAR2(25)
- PostCode (POSTCODE) — VARCHAR2(10)
- Address1 (ADDRESS1) — VARCHAR2(200)
- Address2 (ADDRESS2) — VARCHAR2(200)
- MemCode (MEMCODE) — NUMBER
- Join_Date (JOIN_DATE) — TIMESTAMP
Memcode
- Memcode (MEMCODE) — NUMBER — Primary key — NOT NULL
- Grade (GRADE) — VARCHAR2(50)
Notice
- NoticeID (SEQ) — NUMBER — Primary key — NOT NULL
- UserName (NICKNAME) — VARCHAR2(30)
- NoticeTitle (TITLE) — VARCHAR2(300)
- NoticeContent (CONTENT) — VARCHAR2(4000)
- WRITE_DATE — TIMESTAMP
- View_Count (VIEW_COUNT) — NUMBER
Q&A
- Question_ID (QUESTION_SEQ) — NUMBER — Primary key — NOT NULL
- UserID (USERID) — VARCHAR(30)
- Question (QUESTION) — VARCHAR2(4000)
- Write_date (WRITE_DATE) — TIMESTAMP
- AnswerYN (ANSWER_YN) — CHAR(1)
- Answer_Count (ANSWER_COUNT) — NUMBER
- Answer_Date (ANSWER_DATE) — TIMESTAMP
Rank
- ScoreID (SCORE_SEQ) — NUMBER — Primary key — NOT NULL
- Score (SCORE) — NUMBER
- GameCode (GAMECODE) — NUMBER
- UserName (NICKNAME) — VARCHAR(30)
Reply
- ReplyID (REPLY_SEQ) — NUMBER — Primary key — NOT NULL
- BoardID (PARENT_SEQ) — NUMBER
- UserName (NICKNAME) — VARCHAR2(30)
- Content (CONTENT) — VARCHAR2(4000)
- Write_Date (WRITE_DATE) — TIMESTAMP
- Thumbs_Up (THUMBS_UP) — NUMBER