karutomo

Tables (13)

Board_comments (Untitled11)

  • gb_id — INTEGER — Foreign key → Group_boards.gb_id — NOT NULL
  • bc_user (bc_us) — INTEGER — Foreign key → Users.id — NOT NULL
  • bc_comments — TEXT
  • bc_date — DATE(NOW)

Buy_storys (Untitled13)

  • us_id — INTEGER — Foreign key → Users.id — NOT NULL
  • st_id — INTEGER — Foreign key → Storys.st_id — NOT NULL

Cards (Untitled5)

  • dk_id — AUTO_INCREMENTS — Foreign key → Decks.dk_id — NOT NULL
  • cd_img — VARCHAR — Foreign key → Decks.dk_img — NOT NULL
  • cd_num — INTEGER
  • cd_name — VARCHAR
  • cd_circle — VARCHAR
  • cd_line — INTEGER
  • cd_voice — VARCHAR

Decks (Untitled4)

  • dk_id — AUTO_INCREMENTS — Primary key — NOT NULL
  • dk_maker — INTEGER — Foreign key → Users.id — NOT NULL
  • dk_img (dk_id2) — VARCHAR — Foreign key → Cards.dk_id — NOT NULL
  • dk_title — VARCHAR
  • dk_explain — AUTO_INCREMENTS

Friends (Untitled8)

  • us_id — INTEGER — Foreign key → Users.id — NOT NULL
  • get_id — INTEGER — Foreign key → Users.id — NOT NULL

Games (Untitled9)

  • gm_id — AUTO_INCREMENTS — Primary key — NOT NULL
  • gm_deck — INTEGER — Foreign key → Decks.dk_id — NOT NULL
  • gm_winner — AUTO_INCREMENTS — Foreign key → Users.id — NOT NULL
  • gm_playtime — AUTO_INCREMENTS

Group_boards (Untitled3)

  • gb_id — AUTO_INCREMENTS — Primary key — NOT NULL
  • gb_writer — INTEGER — Foreign key → Users.us_group — NOT NULL
  • gb_writer_group — INTEGER — Foreign key → Groups.gp_master — NOT NULL
  • gb_title — INTEGER
  • gb_context — TEXT
  • gb_date — DATE

Groups (Untitled2)

  • gp_id — INTEGER — Primary key — NOT NULL
  • gp_master — INTEGER — Foreign key → Users.id — NOT NULL
  • gp_name — VARCHAR
  • gp_explain — TEXT
  • gp_img — VARCHAR

Personal accounts (Untitled10)

  • pa_usId (ps_us_id) — INTEGER — Foreign key → Users.id — NOT NULL
  • gm_id — INTEGER — Foreign key → Games.gm_id — NOT NULL
  • pa_score — AUTO_INCREMENTS
  • pa_combo — INTEGER
  • pa_answer — INTEGER

Storys (Untitled12)

  • st_id — AUTO_INCREMENTS — Primary key — NOT NULL
  • st_title (st_titld) — VARCHAR
  • st_context — TEXT
  • st_img — VARCHAR
  • st_prices (st_price) — AUTO_INCREMENTS

Subscriptions (Untitled7)

  • us_id (id) — INTEGER — Foreign key → Users.id — NOT NULL
  • dk_id — AUTO_INCREMENTS — Foreign key → Decks.dk_id — NOT NULL

Tags (Untitled6)

  • dk_id — INTEGER — Foreign key → Decks.dk_id — NOT NULL
  • dk_tag — VARCHAR

Users (Untitled)

  • id — AUTO_INCREMENTS — Primary key — NOT NULL
  • us_group (gp_id) — INTEGER — Foreign key → Groups.gp_id — NOT NULL
  • us_id — VARCHAR
  • us_pw — VARCHAR
  • us_nick — VARCHAR
  • us_img — VARCHAR
  • us_birth — DATE
  • us_gender — INTEGER
  • us_money — INTEGER