aaa

Tables (22)

ADDRESS

  • ADDRESS_NO — NUMBER
  • SIDO — VARCHAR2(100) — NOT NULL
  • GU — VARCHAR2(100)
  • SIGUN — VARCHAR2(100)

ATTENDANCE

  • ATTENDANCE_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • ATTENDANCE_DATE — DATE — NOT NULL

BATTLE

  • BATTLE_NO — NUMBER
  • HOMETEAM_NO — NUMBER — Foreign key → TEAM.TEAM_NO — NOT NULL
  • AWAYTEAM_NO — NUMBER — Foreign key → TEAM.TEAM_NO — NOT NULL
  • SPORTS_NAME — VARCHAR2(30)
  • BATTLE_DATE — DATE — NOT NULL
  • TEAM_INTRO — VARCHAR2(500)
  • AGREE_STATUS — NUMBER
  • RESULT_STATUS — NUMBER

BOARD

  • BOARD_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • ADDRESS_NO — NUMBER — Foreign key → ADDRESS.ADDRESS_NO — NOT NULL
  • BOARD_TITLE — VARCHAR2(300) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(2000) — NOT NULL
  • COUNT — NUMBER
  • CHANGE_NAME — VARCHAR2(300)
  • ORIGIN_NAME — VARCHAR2(300)
  • BOARD_TYPE — NUMBER — NOT NULL
  • CREATE_DATE — DATE — NOT NULL
  • BOARD_STATUS — VARCHAR2(2)

CHATTING

  • CHAT_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • ROOM_NO — NUMBER — Foreign key → CHATTINGROOM.ROOM_NO — NOT NULL

CHATTINGMESSAGE

  • MESSAGE_NO — NUMBER
  • ROOM_NO — NUMBER — Foreign key → CHATTINGROOM.ROOM_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • MESSAGE — VARCHAR2(1000) — NOT NULL
  • MESSAGE_TIME — VARCHAR2(30) — NOT NULL

CHATTINGROOM

  • ROOM_NO — NUMBER
  • ROOM_ID — VARCHAR2(300) — NOT NULL
  • ROOM_NAME — VARCHAR2(100)
  • ROOM_CHECK — VARCHAR2(30)

GYM

  • GYM_NO — NUMBER
  • RESERVATION_NO — NUMBER — Foreign key → RESERVATION.RESERVATION_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • ADDRESS_NO — NUMBER — Foreign key → ADDRESS.ADDRESS_NO — NOT NULL
  • GYM_NAME — VARCHAR2(100) — NOT NULL
  • GYM_STATUS — NUMBER — NOT NULL

MARK

  • MARK_NO — NUMBER
  • MARK_NAME — VARCHAR2(50) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • MARK_CONTENT — VARCHAR2(500)

MEMBER

  • MEMBER_NO — NUMBER
  • MEMBER_ID — VARCHAR2(30)
  • MEMBER_PWD — VARCHAR2(255) — NOT NULL
  • MEMBER_NAME — VARCHAR2(20) — NOT NULL
  • EMAIL — VARCHAR2(50) — NOT NULL
  • PHONE — VARCHAR2(11) — NOT NULL
  • MEMBER_STATUS — VARCHAR2(2) — NOT NULL
  • MARK — VARCHAR2(3)
  • BIRTH_DATE — VARCHAR2(20) — NOT NULL
  • POINT — NUMBER — NOT NULL
  • PLATFORM — NUMBER — NOT NULL
  • AUTHKEY — VARCHAR2(200)

MEMBER_MARK

  • MARK_NO — NUMBER — Foreign key → MARK.MARK_NO — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL

MEMBER_TEAM

  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO
  • TEAM_NO — NUMBER — Foreign key → TEAM.TEAM_NO
  • MEMBER_GRADE — NUMBER
  • JOIN_DATE — DATE — NOT NULL
  • JOIN_STATUS — VARCHAR2(2) — NOT NULL
  • INTRO_MYSELF — VARCHAR2(1000) — NOT NULL

MERCENARY_BOARD

  • BOARD_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • BOARD_TITLE — VARCHAR2(300) — NOT NULL
  • BOARD_CONTENT — VARCHAR2(2000) — NOT NULL
  • COUNT — NUMBER
  • CHANGE_NAME — VARCHAR2(300)
  • ORIGIN_NAME — VARCHAR2(300)
  • BOARD_TYPE — NUMBER — NOT NULL
  • CREATE_DATE — DATE — NOT NULL
  • BOARD_STATUS — VARCHAR2(2)
  • BOARD_SELECT — NUMBER
  • LOCATION — VARCHAR2(30) — NOT NULL

NOTICE

  • NOTICE_NO — NUMBER
  • NOTICE_TITLE — VARCHAR2(300) — NOT NULL
  • NOTICE_CONTENT — VARCHAR2(2000) — NOT NULL
  • COUNT — NUMBER
  • CHANGE_NAME — VARCHAR2(300)
  • ORIGIN_NAME — VARCHAR2(300)
  • CREATE_DATE — DATE — NOT NULL
  • NOTICE_STATUS — VARCHAR2(2) — NOT NULL

PAYMENT

  • PAYMENT_NO — NUMBER — NOT NULL
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • MARK_NO — NUMBER — Foreign key → MARK.MARK_NO — NOT NULL
  • PAYMENT_DATE — DATE — NOT NULL
  • PAYMENT_METHOD — NUMBER — NOT NULL

PURPOSE

  • PURPOSE_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • CURRENT_WEIGHT — NUMBER — NOT NULL
  • CURRENT_FAT — NUMBER — NOT NULL
  • CURRENT_MUSCLE — NUMBER — NOT NULL
  • PURPOSE_WEIGHT — NUMBER — NOT NULL
  • PURPOSE_FAT — NUMBER — NOT NULL
  • PURPOSE_MUSSCLE — NUMBER — NOT NULL
  • SPORTS1 — VARCHAR2(50)
  • SPORTS2 — VARCHAR2(50)
  • SPORTS3 — VARCHAR2(50)
  • PURPOSE_STATUS — NUMBER — NOT NULL

REPLY

  • REPLY_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • REPLY_CONTENT — VARCHAR2(1000) — NOT NULL
  • CREATE_DATE — DATE — NOT NULL
  • REPLY_STATUS — VARCHAR2(2) — NOT NULL

RESERVATION

  • RESERVATION_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • START_TIME — DATE — NOT NULL
  • END_TIME — DATE — NOT NULL
  • RESERVATION_DATE — DATE — NOT NULL

SPORTS

  • SPORTS_NO — NUMBER
  • SPORTS_NAME — VARCHAR(50) — NOT NULL
  • SPORTS_TYPE — NUMBER — NOT NULL
  • BIG_TYPE — NUMBER — NOT NULL
  • MID_TYPE — NUMBER — NOT NULL

SPORTS_DIARY

  • DIARY_NO — NUMBER
  • MEMBER_NO — NUMBER — Foreign key → MEMBER.MEMBER_NO — NOT NULL
  • DIARY_TITLE — VARCHAR2(50) — NOT NULL
  • DIARY_CONTENT — VARCHAR2(500) — NOT NULL
  • DIARY_PHOTO — VARCHAR2(100)
  • DIARY_DATE — DATE — NOT NULL

TEAM

  • TEAM_NO — NUMBER
  • SPORTS_NO — NUMBER — Foreign key → SPORTS.SPORTS_NO — NOT NULL
  • ADDRESS_NO — NUMBER — Foreign key → ADDRESS.ADDRESS_NO — NOT NULL
  • TEAM_NAME — VARCHAR2(100) — NOT NULL
  • CREATE_DATE — DATE — NOT NULL
  • WIN_COUNT — NUMBER — NOT NULL
  • DRAW_COINT — NUMBER — NOT NULL
  • LOSE_COUNT — NUMBER — NOT NULL
  • WIN_POINT — NUMBER — NOT NULL
  • TEAM_INTRO — VARCHAR2(1000) — NOT NULL
  • TEAM_STATUS — VARCHAR2(2) — NOT NULL

TEAM_MARK

  • MARK_NO — NUMBER — Foreign key → MARK.MARK_NO — NOT NULL
  • TEAM_NO — NUMBER — Foreign key → TEAM.TEAM_NO — NOT NULL