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