asap

Tables (8)

BOARD (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • auther (Key2) — bigint — Foreign key → USER.id — NOT NULL
  • title (Field) — string
  • content (Field2) — text
  • reply_cnt (Field3) — int
  • good (Field4) — int
  • bad (Field5) — int

BOARD_REPLY (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • board_id (Key2) — bigint — Foreign key → BOARD.id — NOT NULL
  • reply_author (Key3) — bigint — Foreign key → USER.id — NOT NULL
  • reply_content (Field) — text

FARM (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • serial (Field2) — string
  • name (Field3) — string

MARKET_BUY (Untitled5)

  • id (Key2) — bigint — Primary key — NOT NULL
  • item_buyer (Key) — bigint — Foreign key → USER.id — NOT NULL
  • buy_item (Key3) — bigint — Foreign key → MARKET_REG.id — NOT NULL
  • item_saller (Key22) — bigint — Foreign key → MARKET_REG.saller — NOT NULL
  • reserve_yn (Field) — string

MARKET_REG (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • saller (Key2) — bigint — Foreign key → USER.id — NOT NULL
  • food (Field) — string
  • price (Field2) — int

SENSOR_AVERAGE (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • farm_id (Key2) — bigint — Foreign key → FARM.id — NOT NULL
  • sensor_id (Field) — string
  • timestamp (Field2) — UTC
  • value (Field3) — float

USER (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • username (Field) — string
  • nickname (Field2) — string
  • email (Field3) — string
  • password (Field4) — string
  • phone (Field5) — string
  • money (Field6) — int

USER_FARM (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → USER.id — NOT NULL
  • farm_id (Key3) — bigint — Foreign key → FARM.id — NOT NULL
  • role (Field3) — string