ZeroMarket

Tables (6)

ChatJoin (Untitled3)

  • id (userId) — BIGINT — Foreign key → User.id — NOT NULL
  • id (chatId) — BIGINT — Foreign key → ChatRoom.id — NOT NULL

ChatRoom (Untitled4)

  • id (chatId) — BIGINT — Primary key — NOT NULL
  • name (chatroomName) — VARCHAR(255)
  • status (chatroomstatus) — BOOLEAN
  • createdAt (createdDate) — DATETIME
  • removedAt (removedDate) — DATETIME

Post (Untitled2)

  • id (postId) — BIGINT — Primary key — NOT NULL
  • id (registerUser) — BIGINT — Foreign key → User.id — NOT NULL
  • id (imageId) — BIGINT — Foreign key → image.id — NOT NULL
  • title (post title) — VARCHAR(100)
  • content (post content) — VARCHAR(2000)
  • category (categoryForPost) — VARCHAR(50)
  • price (post price) — INTEGER
  • status (post status) — VARCHAR(10)
  • createdAt (createdDate) — DATETIME
  • modifiedAt (modifiedDate) — DATETIME
  • removedAt (removedDate) — DATETIME
  • bookTime (bookDateTime) — DATETIME
  • hits (watched user number) — BIGINT
  • likes (likes user number) — BIGINT

User (Untitled)

  • id (userId) — BIGINT — Primary key — NOT NULL
  • user_id (id for login) — VARCHAR(255)
  • nickname — VARCHAR(255)
  • role (user role) — VARCHAR(10)
  • password (for login) — VARCHAR(255)
  • createdAt (createdDate) — DATETIME
  • modifiedAt (modifiedDate) — DATETIME
  • removedAt (removedDate) — DATETIME
  • id (intereting post) — BIGINT — Foreign key → Post.id — NOT NULL

image (Untitled6)

  • id (imageId) — BIGINT — Primary key — NOT NULL
  • image1 (Field) — VARCHAR(4000)
  • image2 (Field2) — VARCHAR(4000)
  • image3 (Field3) — VARCHAR(4000)
  • image4 (Field4) — VARCHAR(4000)
  • image5 (Field5) — VARCHAR(4000)
  • image6 (Field6) — VARCHAR(4000)
  • image7 (Field7) — VARCHAR(4000)
  • image8 (Field8) — VARCHAR(4000)
  • image9 (Field9) — VARCHAR(4000)
  • image10 (Field10) — VARCHAR(4000)

message (Untitled5)

  • id (messageId) — BIGINT — Primary key — NOT NULL
  • id (chatId) — BIGINT — Foreign key → ChatJoin.id — NOT NULL
  • message (content) — VARCHAR(4000)
  • sendTime (sendtime) — DATETIME
  • check (read/unread) — BOOLEAN
  • readTime (readtime) — DATETIME
  • bookTime — DATETIME
  • id (imageId) — BIGINT — Foreign key → image.id — NOT NULL