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