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