POP

테이블 (4)

게임 (Untitled2)

  • game_num (Key) — number(10) — 기본 키 — NOT NULL
  • game_name (Field) — varchar(20)
  • game_img (Field2) — mediumblob
  • game_icon (Field3) — mediumblob
  • game_exp (Field4) — varchar(1000)
  • game_link (Field5) — varchar(20)

고객의견 (Untitled4)

  • sug_num (Field) — number(10) — 기본 키
  • mem_id (Key) — varchar(20) — 외래 키 → 회원.mem_id — NOT NULL
  • sug_question (Field2) — varchar(500)
  • sug_answer (Field3) — varchar(500)

공지사항 (Untitled3)

  • noti_num (Key) — number(10) — 기본 키 — NOT NULL
  • noti_category (Field) — varchar(20)
  • noti_title (Field2) — varchar(20)
  • noti_context (Field3) — varchar(20)
  • noti_date (Field4) — date

회원 (Untitled)

  • mem_id (Key) — varchar(20) — 기본 키 — NOT NULL
  • mem_pw (Field) — varchar(20)
  • mem_name (Field2) — varchar(20)
  • mem_phone (Field4) — varchar(20)
  • mem_email (Field3) — varchar(30)
  • mem_nickname (Field5) — varchar(20)
  • mem_zipcode (Field6) — varchar(10)
  • mem_address1 (Field7) — varchar(100)
  • mem_address2 (Field8) — varchar(100)