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