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)

Untitled6

  • Field