mom
Tables (12)
CODE
- CODE_KEY — BIGINT — Primary key — NOT NULL
- CODEGROUP_ID — CHAR(2) — NOT NULL
- POSITION — CHAR(3) — NOT NULL
- CITY — CHAR(2)
COMMENT
- COMMENT_KEY — BIGINT — Primary key — NOT NULL
- CSCENTER_KEY — BIGINT — Foreign key → CSCENTER.CSCENTER_KEY — NOT NULL
- USER_KEY — BIGINT — Foreign key → CSCENTER.USER_KEY — NOT NULL
- COMMENT_CONTENTS — VARCHAR(1000) — NOT NULL
- COMMENT_DATE — DATETIME — NOT NULL
- COMMENT_DEPTH — BIGINT — NOT NULL
- COMMENT_LEVEL — BIGINT — NOT NULL
- COMMENT_GROUPID — BIGINT — NOT NULL
CSCENTER
- CSCENTER_KEY — BIGINT — Primary key — NOT NULL
- USER_KEY — BIGINT(20) — Foreign key → USER.USER_KEY — NOT NULL
- CSCENTER_TITLE — VARCHAR(100) — NOT NULL
- CSCENTER_CONTENTS — TEXT — NOT NULL
- CSCENTER_DATE — DATETIME — NOT NULL
GAME
- GAME_KEY — BIGINT — Primary key — NOT NULL
- TEAM_KEY — BIGINT — Foreign key → TEAM.TEAM_KEY — NOT NULL
- GAME_DATE — DATETIME — NOT NULL
- GAME_LOCATION — VARCHAR(100) — NOT NULL
- GAME_TITLE — VARCHAR(100) — NOT NULL
- GAME_CONTENTS — TEXT — NOT NULL
- GAME_FDATE — DATETIME — NOT NULL
LINEUP
- LINEUP_KEY — BIGINT — Primary key — NOT NULL
- USER_KEY — BIGINT — Foreign key → USER.USER_KEY — NOT NULL
- TEAM_KEY — BIGINT — Foreign key → TEAM.TEAM_KEY — NOT NULL
- GAME_KEY — BIGINT — Foreign key → GAME.GAME_KEY — NOT NULL
- CODE_KEY — BIGINT — Foreign key → CODE.CODE_KEY — NOT NULL
- TEAM_SIDE — CHAR(1) — NOT NULL
MATCHINGJOIN
- MATCHINGJOIN_KEY — BIGINT — Primary key — NOT NULL
- TEAM_KEY — BIGINT — Foreign key → TEAM.TEAM_KEY — NOT NULL
- RESULT_PROC — CHAR(1) — NOT NULL
MEMBERSHIP
- MEMBERSHIP_KEY — BIGINT — Primary key — NOT NULL
- USER_KEY — BIGINT — Foreign key → USER.USER_KEY — NOT NULL
- TEAM_KEY — BIGINT — Foreign key → TEAM.TEAM_KEY — NOT NULL
- MEMBERSHIP_ROLE — CHAR(1) — NOT NULL
- TEAM_JOINDATE — DATETIME — NOT NULL
MERCENARY
- MERCENARY_KEY — BIGINT — Primary key — NOT NULL
- USER_KEY — BIGINT — Foreign key → USER.USER_KEY — NOT NULL
- GAME_KEY — BIGINT — Foreign key → GAME.GAME_KEY — NOT NULL
- MERCENARY_TITLE — VARCHAR(200) — NOT NULL
- MERCENARY_CONTENTS — TEXT — NOT NULL
- MERCENARY_COMPLETE — CHAR(1) — NOT NULL
MERCENARYJOIN
- MERCENARYJOIN_KEY — BIGINT — Primary key — NOT NULL
- MERCENARY_KEY — BIGINT — Foreign key → MERCENARY.MERCENARY_KEY — NOT NULL
- USER_KEY — BIGINT — Foreign key → USER.USER_KEY — NOT NULL
- MERCENARY_PROC — CHAR(1) — NOT NULL
TEAM
- TEAM_KEY — BIGINT(20) — Primary key — NOT NULL
- TEAM_NAME — VARCHAR(100) — NOT NULL
- TEAM_FDATE — DATETIME — NOT NULL
- TEAM_FEE — INT — NOT NULL
- CODE_KEY — BIGINT — Foreign key → CODE.CODE_KEY — NOT NULL
- TEAM_INTRO — TEXT — NOT NULL
- TEAM_EMBLEM — VARCHAR(255) — NOT NULL
- TEAM_NOTICE — TEXT — NOT NULL
- TEAM_NUM — INT — NOT NULL
- TEAM_RECRUIT_YN — CHAR(1) — NOT NULL
TEAMJOIN
- TEAMJOIN_KEY — BIGINT — Primary key — NOT NULL
- TEAM_KEY — BIGINT — Foreign key → TEAM.TEAM_KEY — NOT NULL
- USER_KEY — BIGINT — Foreign key → USER.USER_KEY — NOT NULL
- TEAMJOIN_PROC — CHAR(1) — NOT NULL
USER
- USER_KEY — BIGINT(20) — Primary key — NOT NULL
- USER_ID — VARCHAR(20) — NOT NULL
- USER_PASSWORD — VARCHAR(255) — NOT NULL
- USER_NAME — VARCHAR(100) — NOT NULL
- USER_MAIL — VARCHAR(50) — NOT NULL
- USER_PHONE — VARCHAR(30) — NOT NULL
- USER_ADDRESS1 — VARCHAR(100) — NOT NULL
- USER_ADDRESS2 — VARCHAR(100) — NOT NULL
- USER_POSITION — VARCHAR(20) — NOT NULL
- USER_INTRO — TEXT — NOT NULL