behint_web_demo
Tables (23)
Agreement (Untitled2)
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
- termOfService — bool
- personalInformation — bool
- eventReceive — bool
- createdAt (Field) — datetime
- updatedAt (Field2) — datetime
Alarm (Untitled16)
- userId (id) — int — Foreign key → User.id — NOT NULL
- 1 (Field) — bool
- 2 (Field2) — bool
- 3 (Field3) — bool
- 4 (Field4) — bool
- 5 (Field5) — bool
- createdAt (Field6) — datetime
- updatedAt (Field7) — datetime
Ban (Untitled22)
- senderId (id) — int — Foreign key → User.id — NOT NULL
- receiverId (id2) — int — Foreign key → User.id — NOT NULL
- createdAt (Field) — datetime
Commentary (Untitled10)
- id — int — Primary key — NOT NULL
- projectId — int — Foreign key → Project.id — NOT NULL
- title — varchar(128)
- startTime — time
- endTime — time
- thumbnailImgUrl — text
CommentaryContents (Untitled11)
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
- commentId — int — Foreign key → Commentary.id — NOT NULL
- content — text
CommentaryLike (Untitled12)
- contentId — int — Foreign key → CommentaryContents.id — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
Contract (Untitled20)
- id (Key) — int — Primary key — NOT NULL
- proposalId (Key2) — int — Foreign key → Proposal.id — NOT NULL
- fileName (Field) — text
- fileUrl (Field2) — text
Follow (Untitled13)
- followerId (id) — int — Foreign key → User.id — NOT NULL
- followingId (id2) — int — Foreign key → User.id — NOT NULL
Location (Untitled8)
- id — int — Primary key — NOT NULL
- projectId — int — Foreign key → Project.id — NOT NULL
- locationName — varchar(256)
- latitude — decimal
- longitude — decimal
Message (Untitled18)
- id (Key2) — int — Primary key — NOT NULL
- roomId (Key) — int — Foreign key → MessageRoom.id — NOT NULL
- ReciverId (id) — int — Foreign key → MessageRoom.ReciverId — NOT NULL
- SenderId (id2) — int — Foreign key → MessageRoom.ReciverId — NOT NULL
- content (Field) — text
- check (Field2) — bool
MessageRoom (Untitled17)
- id (Key) — int — Primary key — NOT NULL
- ReciverId (id) — int — Foreign key → User.id — NOT NULL
- SenderId (id2) — int — Foreign key → User.id — NOT NULL
- accept (Field) — bool
- reciverOut (Field2) — bool
- senderOut (Field3) — bool
- reciverReport (Field4) — bool
- senderReport (Field5) — bool
Profile (Untitled)
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
- nickname — varchar(20)
- job — varchar(20)
- location — varchar(20)
- profileImgUrl — text
- introduce — text
- instagramUrl — text
- facebookUrl — text
- tweeterUrl — text
- etcUrl — text
- mainProjects — text
- createdAt (Field) — datetime
- deletedAt (Field2) — datetime
Project (Untitled4)
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
- videoUrl — text
- thumbnailImgUrl — text
- title — varchar(128)
- introduce — text
- copyright — varchar(64)
- position — varchar(64)
- viewCount — int
- visible — bool
- category — varchar(64)
ProjectLike (Untitled7)
- userId — int — Foreign key → User.id — NOT NULL
- projectId — int — Foreign key → Project.id — NOT NULL
- type — varchar(64)
ProjectMember (Untitled9)
- email — text — Primary key — NOT NULL
- projectId — int — Foreign key → Project.id — NOT NULL
- signup (signUp) — bool
- accept — bool
- position — varchar(64)
ProjectTag (Untitled6)
- projectId — int — Foreign key → Project.id — NOT NULL
- tagId — int — Foreign key → Tag.id — NOT NULL
- email — text — Foreign key → ProjectMember.email — NOT NULL
Proposal (Untitled19)
- id (Key2) — int — Primary key — NOT NULL
- roomId (Key) — roomId — Foreign key → MessageRoom.id — NOT NULL
- totle (Field) — varchar(128)
- period (Field2) — varchar(128)
- contnet (Field3) — text
- cost (Field4) — int
- evidence (Field5) — varchar(128)
- type (Field6) — varchar(64)
Report (Untitled21)
- id (Key) — int — Primary key — NOT NULL
- senderId (id) — int — Foreign key → User.id — NOT NULL
- receiverId (id2) — int — Foreign key → User.id — NOT NULL
- type (Field) — varchar(64)
- content (Field2) — text
- condition (Field3) — bool
Scrap (Untitled14)
- id (Key) — int — Primary key — NOT NULL
- userId (id) — int — Foreign key → User.id — NOT NULL
- name (Field) — varchar(128)
- visible (Field2) — bool
ScrapProject (Untitled15)
- id (Key2) — int — Primary key — NOT NULL
- scrapId (Key) — int — Foreign key → Scrap.id — NOT NULL
- projectId (id2) — int — Foreign key → Project.id — NOT NULL
- visible (Field) — bool
Tag (Untitled5)
- id — int — Primary key — NOT NULL
- content — varchar(128)
User
- id — int — Primary key — NOT NULL
- email — text — NOT NULL
- provider — varchar(32) — NOT NULL
- deletedAt (withdraw) — datetime
- createdAt (Field) — datetime
UserInformation (Untitled3)
- id — int — Primary key — NOT NULL
- userId — int — Foreign key → User.id — NOT NULL
- title — varchar(64) — NOT NULL
- startDate — datetime
- endDate — datetime
- position — varchar(64)
- detailContents — text
- informationUrl — text
- createdAt (Field) — datetime
- deletedAt (Field2) — datetime