xc

Tables (10)

COMMENT

  • cOMMENT_KEY (COMMENT_KEY) — bigint(20) — Primary key — NOT NULL
  • CS_CENTERKEY — BIGINT(20) — Foreign key → cs_key.CS_CENTERKEY — NOT NULL
  • USER_KEY (user_key) — BIGINT(20) — Foreign key → cs_key.USER_KEY
  • COMMENT_CONTENTS — VARCHAR(1000)
  • COMMENT_DATE — DATETIME
  • COMMENT_DEPTH — BIGINT(20)
  • COMMENT_LEVEL — BIGINT(20)
  • COMMENT_GROUPID — BIGINT(20)

LOCAL (local)

  • LOCAL_KEY (local_key) — BIGINT(20) — Primary key — NOT NULL
  • LOCAL_SU (local_su) — VARCHAR(20)
  • LOCAL_BS (local_bs) — VARCHAR(20)
  • LOCAL_TK (local_tk) — VARCHAR(20)
  • LOCAL_IC (local_ic) — VARCHAR(20)
  • LOCAL_DJ (local_dj) — VARCHAR(20)
  • LOCAL_US (local_us) — VARCHAR(20)
  • LOCAL_sj (local_sj) — VARCHAR(20)
  • LOCAL_GG (local_gg) — VARCHAR(20)
  • LOCAL_GW (local_gw) — VARCHAR(20)
  • LOCAL_CB (local_cb) — VARCHAR(20)
  • LOCAL_CN (local_cn) — VARCHAR(20)
  • LOCAL_JB (local_jb) — VARCHAR(20)
  • LOCAL_JN (local_jn) — VARCHAR(20)
  • LOCAL_GB (local_gb) — VARCHAR(20)
  • LOCAL_GN (local_gn) — VARCHAR(20)
  • LOCAL_JJ (local_jj) — VARCHAR(20)
  • Field

LineUP

  • LINE_UP (line_up) — BIGINT(20) — Primary key — NOT NULL
  • USER_KEY (user_key) — BIGINT(20) — Foreign key → TEAM.USER_KEY — NOT NULL
  • TEAM-key (team_key) — BIGINT(20) — Foreign key → USER.TEAM-key — NOT NULL
  • GAMEMATHING_KEY — BIGINT(20) — Foreign key → MATCHING.GAMEMATHING_KEY — NOT NULL
  • position — bigint(20) — Foreign key → position.position — NOT NULL

MATCHING

  • GAMEMATHING_KEY — BIGINT(20) — Primary key — NOT NULL
  • GAMEMATCHING_DATE — WDATE — NOT NULL
  • GAMEMATCHING_LOCATION — VARCHAR(100) — NOT NULL
  • GAMEMATCHING_TITLE — VARCHAR(100) — NOT NULL
  • GAMEMATCHING_CONTENTS — VARCHAR(100) — NOT NULL
  • GAMEMATCHING_FDATE — WDATE — NOT NULL
  • GAMEMATCHING_RESULT — BOOLEAN — NOT NULL

MERCENARY

  • mercenary_key (merchnary_key) — BIGINT(20) — Primary key — NOT NULL
  • USER_KEY (user_key) — BIGINT(20) — Foreign key → USER.USER_KEY — NOT NULL
  • GAMEMATHING_KEY (Key) — BIGINT — Foreign key → MATCHING.GAMEMATHING_KEY — NOT NULL
  • TEAM-key (pri) — BIGINT — Foreign key → TEAM.TEAM-key — NOT NULL
  • MERCENARY_TITLE (mercenary_title) — VARCHAR(100)
  • MERCENARY_CONTENTS (mercenary_contents) — TEXT
  • MERCENARY_COMPLETE (MERCENARYT_COMPLETE) — boolean

MUSER

  • MUSER_KEY — BIGINT(20) — Primary key — NOT NULL
  • mercenary_key (merchnary_key) — BIGINT(20) — Foreign key → MERCENARY.mercenary_key — NOT NULL
  • USER_KEY (user_key) — BIGINT(20) — Foreign key → USER.USER_KEY

TEAM

  • TEAM-key — BIGINT — Primary key — NOT NULL
  • USER_KEY (TEAM_DIRECTORKEY) — BIGINT(20) — Foreign key → USER.USER_KEY — NOT NULL
  • TEAM_FDATE — DATE — NOT NULL
  • TEAM_FEE — INT(20) — NOT NULL
  • TEAM_INTRO — VARCHAR(100) — NOT NULL
  • TEAM_EMBLEM — BLOP — NOT NULL
  • TEAM_NOTICE — TEXT — NOT NULL
  • TEAM_RECRUIT — BOOLEAN — NOT NULL
  • TEAM_DIRECTORKEY (TEAM_DIRECTORYKEY) — VARCHAR(100) — NOT NULL
  • LOCAL_KEY (local_key) — BIGINT(20) — Foreign key → LOCAL.LOCAL_KEY — NOT NULL
  • TEAM_NAME (team_name) — VARCHAR(100) — NOT NULL

USER

  • USER_KEY (user_key) — BIGINT(20) — Primary key
  • TEAM-key (team_key) — BIGINT — Foreign key → TEAM.TEAM-key — NOT NULL
  • USER_ID (user_id) — VARCHAR(20) — NOT NULL
  • USER_PASSWORD (user_password) — VAHCHAR(255) — NOT NULL
  • USER_NAME (user_name) — VARCHAR(100) — NOT NULL
  • USER_EMAIL (user_mail) — VARCHAR(30) — NOT NULL
  • USER_PHONE (user_phone) — VARCHAR(30) — NOT NULL
  • USER_ADDRESS (user_address) — VARCHAR(100) — NOT NULL
  • USER_POSITION (user_position) — VARCHAR(20) — NOT NULL
  • USER_ROLE (user_role) — VARCHAR(20) — NOT NULL
  • USER_INTRO (user_intro) — TEXT — NOT NULL
  • USER_ADDRESS1 (useraddress1) — varchar(20) — NOT NULL
  • USER_ADDRESS2 (user_addresss2) — varchar(20)
  • TEAM_JOINDATE (team_joindate) — DATE

cs_key

  • CS_CENTERKEY — BIGINT(20) — Primary key — NOT NULL
  • USER_KEY (user_key) — BIGINT(20) — Foreign key → USER.USER_KEY
  • CSCENTER_CONTENTS (contents_comment) — VARCHAR(1000)
  • CSCENTER_KEY — VARCHAR(1000)
  • CSCENTER_DATE (cscenter_date) — DATETIME
  • CSCENTER_GROUPID — VARCHAR(1000)
  • COMMENT_DEPTH — BIGINT(20)

position

  • position — bigint(20) — Primary key — NOT NULL
  • position-st — varchar(10) — NOT NULL
  • position_lw — varchar(10) — NOT NULL
  • position_rw — varchar(10) — NOT NULL
  • position_cam — varchar(10) — NOT NULL
  • position_cm — varchar(10) — NOT NULL
  • position_cdm — varchar(10) — NOT NULL
  • position_lb — varchar(10) — NOT NULL
  • position_rb — varchar(10) — NOT NULL
  • position_rwb — varchar(10) — NOT NULL
  • position_cb — varchar(10) — NOT NULL
  • position_gk — varchar(10) — NOT NULL