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