원해빗

테이블 (4)

tree_images (Untitled4)

  • id (Key) — integer — 기본 키 — NOT NULL
  • level (Field) — int
  • tree_image_url (Field2) — string

tree_posts (Untitled3)

  • id (Key) — integer — 기본 키 — NOT NULL
  • tree_id (Key2) — integer — 외래 키 → trees.id — NOT NULL
  • user_id (Key3) — integer — 외래 키 → users.id — NOT NULL
  • content (Field) — string
  • image_url (Field2) — string
  • created_at (Field3) — datetime

trees (Untitled2)

  • id (Key) — integer — 기본 키 — NOT NULL
  • user_id (Key2) — integer — 외래 키 → users.id — NOT NULL
  • name (Field) — string
  • level (Field4) — int
  • experience (Field5) — int
  • image_url (Field9) — string
  • access_level (Field3) — enum
  • price (Field8) — int
  • start_date (Field6) — datetime
  • end_date (Field7) — datetime
  • created_at (Field2) — datetime

users (Untitled)

  • id (Key) — integer — 기본 키 — NOT NULL
  • username (Field) — string
  • passwrod (Field2) — string
  • nickname (Field3) — string
  • created_at (Field4) — datetime