spotalk
Tables (13)
ADMIN (Untitled4)
- ADMIN_ID (Key) — VARCHAR(50) — Primary key — NOT NULL
- ADMIN_PWD (Field) — VARCHAR(200) — NOT NULL
- ADMIN_NAME (Field2) — VARCHAR(50) — NOT NULL
- ADMIN_EMAIL (Field3) — VARCHAR(100)
- CDATETIME (Field4) — DATETIME — NOT NULL
ATTENDANCE (CopyOfUntitled3)
- ATTEND_ID (Key) — NUMBER — Primary key — NOT NULL
- ATTEND_DATE (Field) — DATETIME — NOT NULL
- POINT (Field2) — NUMBER — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
BANNER_FILE (CopyOfUntitled4)
- FILE_NO (Key) — INT — Primary key — NOT NULL
- FILE_PATH (Field2) — VARCHAR(200) — NOT NULL
- FILE_NAME (Field3) — VARCHAR(200) — NOT NULL
- ORIGIN_NAME (Field4) — VARCHAR(200)
- FILE_SIZE (Field5) — BIGINT — NOT NULL
- IS_MAIN_BANNER (Field6) — CHAR(1) — NOT NULL
- CDATETIME (Field7) — DATETIME — NOT NULL
- ADMIN_ID (Key2) — VARCHAR(50) — Foreign key → ADMIN.ADMIN_ID — NOT NULL
FOLLOW (Untitled2)
- FOLLOW_ID (Key) — INT — Primary key — NOT NULL
- FOLLOWER_ID (Field) — VARCHAR(30) — NOT NULL
- FOLLOWING_ID (Field2) — VARCHAR(30) — NOT NULL
- CDATETIME (Field3) — DATETIME — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
NOTIFICATION (CopyOfUntitled23)
- NOTI_ID (Key) — INT — Primary key — NOT NULL
- USER_ID (Field) — VARCHAR(30) — NOT NULL
- NOTI_TYPE (Field2) — VARCHAR(20) — NOT NULL
- REF_ID (Field3) — INT
- IS_READ (Field4) — CHAR(1) — NOT NULL
- CDATETIME (Field5) — DATETIME — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
POST (CopyOfUntitled22)
- POST_ID (Key) — INT — Primary key — NOT NULL
- TITLE (Field3) — VARCHAR(100) — NOT NULL
- CONTENT (Field4) — TEXT — NOT NULL
- POST_TYPE (Field5) — VARCHAR(20) — NOT NULL
- EMOTION (Field6) — VARCHAR(20) — NOT NULL
- VIEW_CNT (Field7) — INT — NOT NULL
- LIKE_CNT (Field8) — INT — NOT NULL
- POST_STATUS (Field9) — VARCHAR(10) — NOT NULL
- CDATETIME (Field10) — DATETIME — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
POST_COMMENT (CopyOfUntitled2)
- COMMENT_ID (Key) — INT — Primary key — NOT NULL
- CONTENT (Field3) — VARCHAR(500) — NOT NULL
- CDATETIME (Field4) — DATETIME — NOT NULL
- USER_ID (Key3) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
- POST_ID (Key2) — INT — Foreign key → POST.POST_ID — NOT NULL
POST_IMAGE (CopyOfCopyOfCopyOfUntitled22)
- IMG_ID (Key) — INT — Primary key — NOT NULL
- IMG_PATH (Field3) — VARCHAR(200) — NOT NULL
- IS_MAIN (Field4) — CHAR(1) — NOT NULL
- POST_ID (Key2) — INT — Foreign key → POST.POST_ID — NOT NULL
POST_LIKE (CopyOfCopyOfUntitled2)
- LIKE_ID (Key) — INT — Primary key — NOT NULL
- POST_ID (Field) — INT — NOT NULL
- CDATETIME (Field3) — DATETIME — NOT NULL
- POST_ID (Key2) — INT — Foreign key → POST.POST_ID — NOT NULL
- USER_ID (Key3) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
REPORT (Untitled3)
- REPORT_ID (Key) — INT — Primary key — NOT NULL
- USER_ID (Field) — VARCHAR(30) — NOT NULL
- TARGET_TYPE (Field2) — VARCHAR(20) — NOT NULL
- TARGET_ID (Field3) — INT — NOT NULL
- REASON (Field4) — VARCHAR(500) — NOT NULL
- REPORT_STATUS (Field5) — VARCHAR(10) — NOT NULL
- CDATETIME (Field6) — DATETIME — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
TEAM (CopyOfUntitled)
- TEAM_ID (Key) — INT — Primary key — NOT NULL
- TEAM_NAME (Field) — VARCHAR(30) — NOT NULL
- MASCOT_NAME (Field2) — VARCHAR(30) — NOT NULL
- TEAM_COLOR (Field3) — VARCHAR(20) — NOT NULL
- TEAM_IMG (Field4) — VARCHAR(200)
- CDATETIME (Field5) — DATETIME — NOT NULL
USER_TEAM (CopyOfCopyOfUntitled4)
- USER_TEAM_ID (Key) — NUMBER — Primary key — NOT NULL
- CDATETIME (Field4) — DATETIME — NOT NULL
- USER_ID (Key2) — VARCHAR(30) — Foreign key → users.USER_ID — NOT NULL
- TEAM_ID (Key3) — INT — Foreign key → TEAM.TEAM_ID — NOT NULL
users (Untitled)
- USER_ID (Key) — VARCHAR(30) — Primary key — NOT NULL
- USER_PWD (Field) — VARCHAR](100) — NOT NULL
- NICKNAME (Field2) — VARCHAR(30) — NOT NULL
- PROFILE_IMG (Field3) — VARCHAR(200)
- FAVORITE_TEAM (Field4) — INT
- USER_STATUS (Field5) — VARCHAR(10) — NOT NULL
- CDATETIME (Field6) — DATETIME — NOT NULL
- SOCIALTYPE (Field7) — VARCHAR10)
- EMAIL (Field8) — VARCHAR(100)
- TEAM_ID (Key2) — INT — Foreign key → TEAM.TEAM_ID — NOT NULL