CONSUPPORT-artist
Tables (4)
ARTIST
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- ARTIST_NAME (artistName) — VARCHAR2(100) — NOT NULL
- ARTIST_DETAIL (artistDetail) — VARCHAR2(100) — NOT NULL
ARTIST_IMG
- ARTIST_IMG_CODE (artistImgCode) — VARCHAR2(100) — Primary key — NOT NULL
- USER_ID (userId) — VARCHAR2(100) — Foreign key → User.USER_ID — NOT NULL
- ARTIST_IMG_NAME_ORIGIN (artistImgNameOrigin) — VARCHAR2(100) — NOT NULL
- ARTIST_IMG_NAME_ATTACHED (artistImgNameAttached) — VARCHAR2(100) — NOT NULL
- ARTIST_IMG_IS_MAIN (artistImgIsMain) — VARCHAR2(20) — NOT NULL
User
- USER_ID (userId) — VARCHAR2(100) — Primary key — NOT NULL
- USER_PW (userPw) — VARCHAR2(100) — NOT NULL
- USER_NAME (userName) — VARCHAR2(100) — NOT NULL
- USER_ADDR (userAddr) — VARCHAR2(100) — NOT NULL
- USER_ADDR_DETAIL (userAddrDetail) — VARCHAR2(100)
- USER_BIRTH (userBirth) — VARCHAR2(100) — NOT NULL
- USER_TELL (userTell) — VARCHAR2(100) — NOT NULL
- USER_ROLE (userRole) — VARCHAR2(20) — NOT NULL
- USER_STATUS (userStatus) — VARCHAR2(20) — NOT NULL