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