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