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