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)