Parking

Tables (9)

Faq (faq)

  • Key (seq_no) — Primary key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (created_date)
  • Field (updated_date)

Notice (notice)

  • Key (seq_no) — Primary key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (created_date)
  • Field (updated_date)

Parking (parking)

  • Key (seq_no) — Primary key — NOT NULL
  • user_no — Foreign key → User.user_no — NOT NULL
  • Field (title)
  • Field (address)
  • Field (longitude)
  • Field (latitude)
  • Field (created_date)
  • Field2 (updated_date)

Role (role)

  • Key (seq_no) — Primary key — NOT NULL
  • user_no — Foreign key → User.user_no — NOT NULL
  • Field (role)

Talk (talk)

  • Key (seq_no) — Primary key — NOT NULL
  • Key (room_id) — Foreign key → TalkRoom.Key — NOT NULL
  • Field (created_date)
  • Field (updated_date)

TalkRoom (talk_room)

  • Key (room_id) — Primary key — NOT NULL
  • Key (trade_seq_no) — Foreign key → Trade.Key — NOT NULL
  • Field (created_date)
  • Field2 (updated_date)

Trade (trade)

  • Key (seq_no) — Primary key — NOT NULL
  • Field (type)
  • Field (state)
  • Field (visibility)
  • Field (title)
  • Field (content)
  • Field (price)
  • Field (created_date)
  • Field (updated_date)

TradeImage (trade_image)

  • Key (seq_no) — Primary key — NOT NULL
  • Field (file_nm)
  • Field2 (save_file_nm)
  • Field3 (suffix)
  • Field4 (size)
  • Field5 (save_path)
  • Field6 (image_url)

User (user)

  • user_no — Primary key — NOT NULL
  • Field (email)
  • Field (password)
  • Field (name)
  • Field (phone_no)
  • Field (profile_image)
  • Field (created_date)
  • Field2 (updated_date)