StreetCat

Tables (5)

BOARD

  • BORAD_ID — BIGINT — Primary key — NOT NULL
  • USER_ID — INT — Foreign key → USER.USER_ID — NOT NULL
  • TITLE — VARCHAR(100)
  • CONTENT — VARCHAR(500)
  • CREATED_TIME — TIMESTAMP
  • UPDATED_TIME — TIMESTAMP
  • REGION — VARCHAR(100)

COMMENT

  • COMMENT_ID — BIGINT — Primary key — NOT NULL
  • BORAD_ID — BIGINT — Foreign key → BOARD.BORAD_ID — NOT NULL
  • USER_ID — INT — Foreign key → BOARD.USER_ID — NOT NULL
  • COMMENT_TEXT — VARCHAR(500)
  • CREATED_TIME — TIMESTAMP
  • UPDATED_TIME — TIMESTAMP

IMAGE

  • IMAGE_ID — BIGINT — Primary key — NOT NULL
  • BORAD_ID — BIGINT — Foreign key → BOARD.BORAD_ID — NOT NULL
  • PATH — VARCHAR(255)

SEARCH

  • SEARCH_ID — INT — Primary key — NOT NULL
  • KEY — VARCHAR(50)

USER

  • USER_ID — INT — Primary key — NOT NULL
  • USERNAME — VARCHAR(50)
  • PASSWORD — VARCHAR(50)
  • NAME — VARCHAR(50)
  • EMAIL — VARCHAR(100)
  • ADDRESS — VARCHAR(255)
  • PHONENUMBER — VARCHAR(100)