erdtest
Tables (22)
BAND
- BAND_NO — NUMBER — Primary key — NOT NULL
- BAND_NAME — VARCHAR2(100) — NOT NULL
- BAND_GENRE — VARCHAR2(50)
BAND_BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL
- BOARD_TITLE — VARCHAR2(150) — NOT NULL
- BOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- READ_COUNT — NUMBER — NOT NULL
- BOARD_ST — CHAR(1) — NOT NULL
- USER_NO — NUMBER — NOT NULL
- BOARD_LIKE — NUMBER — NOT NULL
- BOARD_TAG — VARCHAR2(50) — NOT NULL
- BAND_NO — NUMBER — NOT NULL
BAND_BOARD_IMG
- IMG_NO — NUMBER — Primary key — NOT NULL
- IMG_RENAME — VARCHAR2(500) — NOT NULL
- IMG_ORIGINAL — VARCHAR2(500) — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- IMG_LEVEL — NUMBER
BAND_BOARD_REPLY
- REPLY_NO — NUMBER — Primary key — NOT NULL
- REPLY_CONTENT — VARCHAR2(2000) — NOT NULL
- REPLY_ST — CHAR(1) — NOT NULL
- CREATE_DT — DATE — NOT NULL
- USER_NO — NUMBER — NOT NULL
- PARENT_REPLY_NO — NUMBER
- BOARD_NO — NUMBER — NOT NULL
BAND_USER
- BAND_NO — NUMBER — NOT NULL
- USER_NO — NUMBER — NOT NULL
- LEADER_FL — CHAR(2) — NOT NULL
BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL
- BOARD_TITLE — VARCHAR2(150) — NOT NULL
- BOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- READ_COUNT — NUMBER — NOT NULL
- BOARD_ST — CHAR(1) — NOT NULL
- USER_NO — NUMBER — NOT NULL
- BOARD_LIKE — NUMBER — NOT NULL
- BOARD_TAG — VARCHAR2(50) — NOT NULL
BOARD_BANNED
- BANNED_NO — NUMBER
- USER_NO — NUMBER — NOT NULL
- BANNED_USER_NO — NUMBER — NOT NULL
BOARD_IMG
- IMG_NO — NUMBER — Primary key — NOT NULL
- IMG_RENAME — VARCHAR2(500) — NOT NULL
- IMG_ORIGINAL — VARCHAR2(500) — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
CHAT_MESSAGE
- CM_NO — NUMBER — Primary key — NOT NULL
- CHAT_ROOM_NO — VARCHAR2(255) — Foreign key → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- MESSAGE — VARCHAR2(4000) — NOT NULL
- CHAT_DATE — DATE
- USER_NO — NUMBER — NOT NULL
CHAT_ROOM
- CHAT_ROOM_NO — VARCHAR2(300) — Primary key — NOT NULL
- TITLE — VARCHAR2(200) — NOT NULL
- STATUS — CHAR(1)
- USER_NO — NUMBER — NOT NULL — 채팅방연사람
- GUEST_NO — NUMBER
LESSON_INFO
- LESSON_NO — NUMBER
- USER_NO — NUMBER — NOT NULL
- INTRO_MENT — VARCHAR2(1000) — NOT NULL
- JOIN_DATE — DATE
- LESSON_IMG — VARCHAR2(500) — NOT NULL
- GENRE — VARCHAR2(300) — NOT NULL
- INTS — VARCHAR2(300) — NOT NULL
- REGION — VARCHAR2(300) — NOT NULL
- DETAIL_MENT — VARCHAR2(2000) — NOT NULL
- SOCIAL_SITE — VARCHAR2(500) — NOT NULL
MASTER
- MASTER_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
MATCHING_INFO
- MATCHING_NO — NUMBER — Primary key — NOT NULL
- USER_NO — NUMBER — NOT NULL
- INST — VARCHAR2(50)
- GENRE — VARCHAR2(30)
- REGION — VARCHAR2(40)
- GENDER — CHAR(1)
- YEARS_OF_EXP — VARCHAR2(3000)
MESSAGE_BOX
- MSG_NO — NUMBER
- SEND_USER_NO — NUMBER
- RECEIVER_USER_NO — NUMBER
- MSG_CONTENT — VARCHAR2(2000)
- OPEN_DATE — DATE
- SEND_DATE — DATE
PRACTICE_ROOM
- ROOM_NO — NUMBER — Primary key — NOT NULL
- PRICE_PER_HOUR — NUMBER — NOT NULL
- ROOM_IMG — VARCHAR2(200)
- OWNER_NO — NUMBER — NOT NULL
- REGION — VARCHAR2(50) — NOT NULL
- TAG — VARCHAR2(500) — NOT NULL
- ROOM_NAME — VARCHAR2(100) — NOT NULL
- INTRO_ROOM_MENT — VARCHAR2(4000) — NOT NULL
- FACILITY_MENT — VARCHAR2(4000) — NOT NULL
- WARNNING_MENT — VARCHAR2(4000) — NOT NULL
REPLY
- REPLY_NO — NUMBER — Primary key — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- REPLY_CONTENT — VARCHAR2(2000) — NOT NULL
- REPLY_ST — CHAR(1) — NOT NULL
- CREATE_DT — DATE — NOT NULL
- USER_NO — NUMBER — NOT NULL
- PARENT_REPLY_NO — NUMBER
ROOM_OWNER
- OWNER_NO — NUMBER — Primary key — NOT NULL
- OWNER_EMAIL — VARCHAR2(200) — NOT NULL
- OWNER_PWD — VARCHAR2(100) — NOT NULL
- SECESSION_FL — CHAR(2) — NOT NULL
- OWNER_NICK — VARCHAR2(50) — NOT NULL
- COMP_REG_NO — NUMBER — NOT NULL
ROOM_TIME
- TIME_NO — NUMBER — Primary key — NOT NULL
- ROOM_NO — NUMBER — NOT NULL
- RESERVE_USER_NO — NUMBER — NOT NULL
- RESERVE_TIME — NUMBER — NOT NULL
- RESERVE_DAY — VARCHAR2(50) — NOT NULL
SECOND_HAND_BOARD
- BOARD_NO — NUMBER — Primary key — NOT NULL
- BOARD_TITLE — VARCHAR2(150) — NOT NULL
- BOARD_CONTENT — VARCHAR2(4000) — NOT NULL
- CREATE_DATE — DATE — NOT NULL
- BOARD_ST — CHAR(1) — NOT NULL
- PRICE — NUMBER — NOT NULL
- PRODUCT_NM — VARCHAR2(150) — NOT NULL
- USER_NO — NUMBER — NOT NULL
- BOARD_TAG — VARCHAR2(50) — NOT NULL
- REGION — VARCHAR2(50) — NOT NULL
SECOND_HAND_BOARD_IMG
- IMG_NO — NUMBER — Primary key — NOT NULL
- IMG_RENAME — VARCHAR2(500) — NOT NULL
- IMG_ORIGINAL — VARCHAR2(500) — NOT NULL
- BOARD_NO — NUMBER — NOT NULL
- IMG_LEVEL — NUMBER
SECOND_HAND_BOARD_REPLY
- REPLY_NO — NUMBER — Primary key — NOT NULL
- REPLY_CONTENT — VARCHAR2(2000) — NOT NULL
- REPLY_ST — CHAR(1) — NOT NULL
- CREATE_DT — DATE — NOT NULL
- USER_NO — NUMBER — NOT NULL
- PARENT_REPLY_NO — NUMBER
- BOARD_NO — NUMBER — NOT NULL
USER
- USER_NO — NUMBER — Primary key — NOT NULL
- USER_EMAIL — VARCHAR2(200) — NOT NULL
- USER_PWD — VARCHAR2(100) — NOT NULL
- JOIN_DATE — DATE — NOT NULL
- SECESSION_FL — CHAR(2) — NOT NULL
- USER_NICK — VARCHAR2(50) — NOT NULL
- MATCHING_FL — CHAR(2) — NOT NULL
- USER_TYPE — VARCHAR2(20) — NOT NULL
- INTRO_MENT — VARCHAR2(3000)
- BANNED_FL — CHAR(2) — NOT NULL