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