zerofutsal

Tables (11)

BRANCH

  • BRANCH_NO (Key) — NOTNULL — Primary key — NOT NULL
  • BRANCH_CODE — NOTNULL — NOT NULL
  • BRANCH_NAME — NOTNULL — NOT NULL
  • BRANCH_ADDRESS — NOTNULL — NOT NULL
  • BRANCH_TELL — NOTNULL — NOT NULL
  • BRANCH_PIC — NOTNULL — NOT NULL

CUP_MATCH_DETAIL

  • DETAIL_NO (Key) — NOT NULL — Primary key — NOT NULL
  • DETAIL_TEAM_HOME_GOAL — NOT NULL
  • DETAIL_TEAM_AWAY_GOAL — NOT NULL
  • DETAIL_HOME_YELLOW_CARD — NOT NULL
  • DETAIL_AWAY_YELLOW_CARD — NOT NULL
  • DETAIL_HOME_RED_CARD — NOT NULL
  • DETAIL_AWAY_RED_CARD — NOT NULL

CUP_MATCH_SCHEDULE

  • SCHEDULE_NO (Key2) — NOTNULL — Primary key — NOT NULL
  • TEAM_NO (Key4) — NOTNULL — Foreign key → CUP_TEAM.TEAM_NO — NOT NULL
  • DETAIL_NO (Key) — NOTNULL — Foreign key → CUP_MATCH_DETAIL.DETAIL_NO — NOT NULL
  • BRANCH_NO (Key23) — NOTNULL — Foreign key → CUP_TEAM.BRANCH_NO — NOT NULL
  • SCHEDULE_LOCATION — NOTNULL
  • SCHEDULE_DATE — NOTNULL
  • SCHEDULE_TIME — NOTNULL
  • SCHEDULE_HOME_GOAL — NOTNULL
  • SCHEDULE_AWAY_GOAL — NOTNULL

CUP_PLAYER

  • PLAYER_NO (Key2) — NOT NULL — Primary key — NOT NULL
  • TEAM_NO (Key4) — NOTNULL — Foreign key → CUP_TEAM.TEAM_NO — NOT NULL
  • BRANCH_NO (Key23) — NOTNULL — Foreign key → CUP_TEAM.BRANCH_NO — NOT NULL
  • MEM_NO (Key5) — NOT NULL — Foreign key → member.MEM_NO — NOT NULL
  • PLAYER_NAME — NOT NULL — NOT NULL
  • PLAYER_PHOTO — NOT NULL — NOT NULL
  • PLAYER_GAMES — NOT NULL
  • PLAYER_GOAL — NOT NULL
  • PLAYER_YELLOW_CARD — NOT NULL
  • PLAYER_RED_CARD — NOT NULL

CUP_TEAM

  • TEAM_NO (Key) — NOTNULL — Primary key — NOT NULL
  • BRANCH_NO (Key2) — NOTNULL — Foreign key → BRANCH.BRANCH_NO — NOT NULL
  • TEAM_NAME — NOT NULL — NOT NULL
  • TEAM_LEADER — NOT NULL — NOT NULL
  • TEAM_PHONE — NOT NULL — NOT NULL
  • TEAM_MAIL — NOT NULL — NOT NULL
  • TEAM_UNIFORM_HOME — NOT NULL — NOT NULL
  • TEAM_UNIFORM_AWAY — NOT NULL — NOT NULL
  • TEAM_EMBLEM — NOT NULL — NOT NULL
  • TEAM_PASSWORD — NOT NULL — NOT NULL
  • TEAM_CODE — NOT NULL — NOT NULL
  • TEAM_MEMBER_CNT — NOT NULL — NOT NULL
  • TEAM_REG_YEAR — NOT NULL — NOT NULL

FAQ

  • FAQ_NO (Key) — NOT NULL — Primary key — NOT NULL
  • MEM_NO (Key2) — NOT NULL — Foreign key → member.MEM_NO — NOT NULL
  • FAQ_TITLE — NOT NULL — NOT NULL
  • FAQ_CONTENT — NOT NULL — NOT NULL
  • FAQ_HIT — NOT NULL — NOT NULL
  • FAQ_DATE — NOT NULL — NOT NULL

NOTICE

  • NOTICE_NO — NOT NULL — NOT NULL
  • NOTICE_TITLE — NOT NULL — NOT NULL
  • NOTICE_CONTENT — NOT NULL — NOT NULL
  • NOTICE_HIT — NOT NULL — NOT NULL
  • NOTICE_DATE — NOT NULL — NOT NULL
  • NOTICE_IMAGENAME — NOT NULL

RESERVATION

  • RE_NO (Key2) — NOTNULL — Primary key — NOT NULL
  • TIME_NO (Key) — NOTNULL — Foreign key → TIME.TIME_NO — NOT NULL
  • STADIUM_NO (Key3) — NOTNULL — Foreign key → STADIUM.STADIUM_NO — NOT NULL
  • BRANCH_NO (Key4) — NOTNULL — Foreign key → BRANCH.BRANCH_NO — NOT NULL
  • RE_NAME — NOTNULL — NOT NULL
  • RE_TEL1 — NOTNULL — NOT NULL
  • RE_TEL2 — NOTNULL — NOT NULL
  • RE_TEL3 — NOTNULL — NOT NULL
  • RE_PWD — NOTNULL — NOT NULL
  • RE_DATE — NOTNULL — NOT NULL
  • RE_TOTALPAY — NOTNULL — NOT NULL
  • RE_MEMO — NOTNULL
  • RE_PAYMENT — NOTNULL
  • Field

STADIUM

  • STADIUM_NO (Key) — NOTNULL — Primary key — NOT NULL
  • STADIUM_NAME — NOTNULL — NOT NULL
  • STADIUM_SIZE — NOTNULL — NOT NULL

TIME

  • TIME_NO (Key) — NOTNULL — Primary key — NOT NULL
  • TIME_START — NOTNULL — NOT NULL
  • TIME_END — NOTNULL — NOT NULL

member

  • MEM_NO (Key) — NOT NULL — Primary key — NOT NULL
  • MEM_ID (mem_id) — NOTNULL
  • MEM_PW (mem_pw) — NOTNULL
  • MEM_NAME (mem_name) — NOTNULL
  • MEM_PHONE (mem_phone) — NOTNULL
  • AC_TYPE (ac_type) — NOTNULL — NOT NULL