qwer

Tables (7)

CHATTING_ROOM

  • RoomId — Primary key — NOT NULL
  • USER_ID — Foreign key → USER.USER_ID — NOT NULL

ITEM

  • ITEM_ID — Primary key — NOT NULL
  • USER_ID — Foreign key → USER.USER_ID — NOT NULL
  • TITLE
  • PHOTOS
  • DESCRIPTIONS
  • PLACE
  • DATE
  • VIEW_COUNT

ITEM_HISTORY

  • ITEM_ID — Foreign key → ITEM.ITEM_ID — NOT NULL
  • USER_ID — Foreign key → ITEM.USER_ID — NOT NULL

ITEM_TYPE

  • ITEM_ID — Foreign key → ITEM.ITEM_ID — NOT NULL
  • USER_ID — Foreign key → ITEM.USER_ID — NOT NULL
  • name

USER

  • USER_ID — Primary key — NOT NULL
  • EMAIL
  • 학번
  • NAME
  • 학부
  • NICKNAME
  • PHONE
  • TEMPERATURE

USER_RULE

  • ID — Primary key — NOT NULL
  • USER_ID — Foreign key → USER.USER_ID — NOT NULL
  • NAME

WISH

  • USER_ID — Foreign key → USER.USER_ID — NOT NULL
  • ITEM_ID — Foreign key → ITEM.ITEM_ID — NOT NULL