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