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 — 가입일