futsal
Tables (11)
TBL_BOARD (Untitled10)
- BOARD_NUM(SEQ) (Field2) — varchar2(100) — Primary key
- USERID (userid) — varchar2(100) — Foreign key → TBL_MEMBER.USERID
- BOARD_TLTLE (Field) — varchar2(100)
- BOARD_CONTENTS (Field3) — varchar2(1000)
- BOARD_DATE (Field4) — varchar2(100)
- BOARD_READ_CNT (Field5) — varchar2(100)
TBL_BOARD_IMG (Untitled12)
- BOARD_NUM(SEQ) (Field2) — varchar2(100) — Foreign key → TBL_BOARD.BOARD_NUM(SEQ)
- BOARD_FILENAME (Field) — varchar2(100)
- BOARD_REALNAME (Field3) — varchar2(100)
TBL_GROUND (Untitled3)
- GROUND_NAME (ground_name) — varchar2(100) — Primary key
- GROUND_AREA (ground_area) — varchar2(100) — Primary key
- SPONSOR_ID (sponsor_Id) — varchar2(100) — Foreign key → TBL_SPONSOR.SPONSOR_ID
- GROUND_USE_PEOPLE (ground_use_people) — varchar2(100)
- GROUND_MARKET (ground_market) — varchar2(100)
- GROUND_DELIVERY (ground_delivery) — varchar2(100)
- GROUND_CAFE (ground_cafe) — varchar2(100)
- SPONSOR_NAME (sponsor_name) — varchar2(100)
- Field
TBL_GROUND_INFO (Untitled4)
- GROUND_NUM(SEQ) (ground_num) — varchar2(100) — Primary key — NOT NULL
- START_TIME (start_time) — varchar2(100) — Primary key
- END_TIME (end_time) — varchar2(100) — Primary key
- GROUND_NAME (ground_name) — varchar2(100) — Foreign key → TBL_GROUND.GROUND_NAME
- GROUND_AREA (ground_area) — varchar2(100) — Foreign key → TBL_GROUND.GROUND_AREA
- GROUND_FEE_WEEKDAY (ground_fee_weekday) — varchar2(100)
- GROUND_FEE_WEEKEND (ground_fee_weekend)
TBL_MEMBER (Untitled)
- USERID (userid) — varchar2(100) — Primary key
- USERPW (userpw) — varchar2(100)
- USERNAME (username) — varchar2(100)
- usergender — varchar2(10)
- USERPHONE — varchar2(100)
- USERPOSTCODE (userpostcode) — varchar2(100)
- USERADDR (useraddr) — varchar2(100)
- USERADDRDETAIL (useraddrdetail) — varchar2(100)
- USERADDRETC (useraddretc) — varchar2(100)
TBL_REPLY (Untitled11)
- BOARD_NUM(SEQ) (Field2) — NUMBER(10) — Foreign key → TBL_BOARD.BOARD_NUM(SEQ)
- USERID (userid) — varchar2(100) — Foreign key → TBL_BOARD.USERID
- REPLY_NUM(SEQ) (Field) — number(10)
- REPLY_CONTENTS (Field3) — varchar2(1000)
TBL_RESERVATION (Untitled5)
- RESERVE_NUMBER(SEQ) (reserve_number_seq) — varchar2(100) — Primary key
- USERID (userid2) — varchar2(100) — Foreign key → TBL_MEMBER.USERID
- GROUND_NAME (ground_name) — varchar2(100) — Foreign key → TBL_GROUND.GROUND_NAME
- GROUND_NUM(SEQ) (ground_num) — number(10) — Foreign key → TBL_GROUND_INFO.GROUND_NUM(SEQ) — NOT NULL
- START_TIME (start_time2) — varchar2(100) — Foreign key → TBL_GROUND_INFO.START_TIME
- END_TIME (end_time2) — varchar2(100) — Foreign key → TBL_GROUND_INFO.END_TIME
- GROUND_AREA (ground_area) — varchar2(100) — Foreign key → TBL_GROUND.GROUND_AREA
TBL_SPONSOR (Untitled2)
- SPONSOR_ID (sponsor_Id) — varchar2(100) — Primary key
- SPONSOR_PW (sponsor_pw) — varchar2(100)
- SPONSOR_NAME (sponsor_name) — varchar2(100)
- SPONSOR_PHONE (sponsor_phone) — varchar2(100)
- SPONSOR_POINT (sponsor_point) — varchar2(100)
- GROUND_NAME (ground_name) — varchar2(100)
TBL_TEAM (Untitled7)
- TEAMID (teamid) — varchar2(100) — Primary key
- TEAM_IMG (team_img) — varchar2(100) — Primary key
- USERID (userid) — varchar2(100) — Foreign key → TBL_MEMBER.USERID
- TEAM_MAKE_DATE (team_make_date) — varchar2(100)
- TEAM_SKILL (team_skill) — varchar2(100)
- TEAM_AGE (team_age) — varchar2(100)
- TEAM_UNIFORM_COLOR (team_uniform_color) — varchar2(100)
TEAM_LOGO_IMG (Untitled8)
- TEAMID (teamid) — varchar2(100) — Foreign key → TBL_TEAM.TEAMID
- TEAM_IMG (team_img) — varchar2(100) — Foreign key → TBL_TEAM.TEAM_IMG
- Field2
- IMAGE(SEQ) (image(seq)) — number(10)