egodaeyeo
Tables (11)
Bookmark (CopyOfCopyOfusers2)
- bookmark_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL — FK
- item_id (user_id3) — int — Foreign key → Item.item_id — NOT NULL — FK
Category (CopyOfusers2)
- category_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- name (email) — varchar(30) — NOT NULL
ChatMessage (CopyOfCopyOfCopyOfCopyOfCopyOfusers2)
- chat_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- user_id (user_id2) — BIGINT — Foreign key → User.user_id — NOT NULL — FK
- chatroom_id (user_id3) — BIGINT — Foreign key → ChatRoom.chatroom_id — NOT NULL — FK
- content (Field) — varchar(100)
- is_read (Field2) — boolean — NOT NULL — default=false
- created_at (Field3) — datetime(6) — NOT NULL
- application (Field4) — boolean — NOT NULL — default=false
- contract_type (Field5) — varchar(6) — 신청유형
ChatRoom (CopyOfCopyOfCopyOfusers222)
- chatroom_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- inquirer_id (user_id3) — BIGINT — Foreign key → User.user_id — NOT NULL — FK
- author_id (user_id2) — BIGINT — Foreign key → Item.item_id — NOT NULL — FK
- item_id (user_id22) — BIGINT — Foreign key → Item.user_id — NOT NULL — FK
- contract_id (user_id33) — BIGINT — Foreign key → Contract.item_id — NOT NULL — FK
Contract (CopyOfCopyOfCopyOfusers2)
- deal_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL — FK
- item_id (user_id3) — int — Foreign key → Item.item_id — NOT NULL — FK
- status (Field) — int — NOT NULL — choices = 대여가능, 검토중, 대여중, 대여종료
- start_date (Field2) — datetime(6) — NOT NULL
- end_date (Field3) — datetime(6) — NOT NULL
Feedback (Untitled)
- feedback_id (Key) — BIGINT — Primary key — NOT NULL — PK
- user_id — int — Foreign key → User.user_id — NOT NULL — FK
- title (Field) — varchar(70) — NOT NULL
- content (Field2) — longtext — NOT NULL — max_length=512
Item (CopyOfusers)
- item_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL — FK
- category_id (user_id3) — int — Foreign key → Category.category_id — NOT NULL — FK
- section (email) — varchar(10) — NOT NULL — choices = borrow, lend
- title (nickname) — varchar(30) — NOT NULL
- content (Field4) — longtext — NOT NULL — max_length=300
- time_unit (Field) — varchar(5) — choices = hour, day, month
- price (Field2) — int
- created_at (Field5) — datetime(6) — NOT NULL — auto_now_add=True
- updated_at (Field6) — datetime(6) — NOT NULL — auto_now=True
- status (Field7) — int — NOT NULL — choices = 대여가능, 검토중, 대여중, 대여종료
ItemImage (CopyOfCopyOfusers22)
- itemimage_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- item_id (user_id2) — BIGINT — Foreign key → Item.item_id — NOT NULL — FK
- image (email) — varchar(100) — NOT NULL — ImageField
Report (CopyOfUntitled)
- feedback_id (Key) — BIGINT — Primary key — NOT NULL — PK
- item_id (user_id2) — BIGINT — Foreign key → Item.item_id — NOT NULL — FK
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL — PK
- title (Field) — varchar(20) — NOT NULL — choices=REPORT_CATEGORY
- content (Field2) — longtext — NOT NULL — max_length=512
Review (CopyOfCopyOfCopyOfusers22)
- review_id (user_id) — BIGINT — Primary key — NOT NULL — PK
- user_id (user_id2) — int — Foreign key → User.user_id — NOT NULL — FK
- item_id (user_id3) — int — Foreign key → Item.item_id — NOT NULL — FK
- content (Field) — longtext — NOT NULL — max_length=50
- star (Field2) — decimal(2,1) — NOT NULL — choices= 1, 2, ...
- created_at (Field3) — datetime(6) — NOT NULL — auto_now_add=True
User (users)
- user_id — BIGINT — Primary key — NOT NULL — PK
- email — varchar(50) — NOT NULL — UK
- nickname — varchar(15) — NOT NULL — UK
- password (Field4) — varchar(256) — NOT NULL
- address (Field3) — longtext — NOT NULL — max_length=256
- image (Field7) — varchar(100)
- score (Field) — int — max=100, min=1
- last_login (Field2) — datetime(6)
- is_active (Field5) — tinyint(1) — NOT NULL
- is_admin (Field6) — tinyint(1) — NOT NULL
- join_date (Field8) — datetime(6) — NOT NULL — 가입일