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