codeNcut
Tables (8)
akbo
- id — INT — NOT NULL
- userId — INT — NOT NULL
- songName — VARCHAR(64) — NOT NULL
- artist — VARCHAR(64) — NOT NULL
- imgPath — VARCHAR(2048) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
band
- id — INT — NOT NULL
- userId — INT — NOT NULL
- title — VARCHAR(32) — NOT NULL
- place — VARCHAR(32) — NOT NULL
- part — VARCHAR(32) — NOT NULL
- description — VARCHAR(128) — NOT NULL
- lat — DOUBLE — NOT NULL
- lng — DOUBLE — NOT NULL
- date — VARCHAR(32) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
buy
- id — INT — NOT NULL
- userId — INT — NOT NULL
- description — VARCHAR(32) — NOT NULL
- model — VARCHAR(32) — NOT NULL
- buyYear — INT — NOT NULL
- price — INT — NOT NULL
- imgPath — VARCHAR(1024) — NOT NULL
- status — VARCHAR(32) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
daily
- id — INT — NOT NULL
- userId — INT — NOT NULL
- title — VARCHAR(32) — NOT NULL
- contents — VARCHAR(64) — NOT NULL
- imgPath — VARCHAR(1024) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
dailycomment
- id — INT — NOT NULL
- userId — INT — NOT NULL
- dailyId — INT — NOT NULL
- contents — VARCHAR(64) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
dailylike
- id — INT — NOT NULL
- userId — INT — NOT NULL
- dailyId — INT — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
form
- id — INT — NOT NULL
- userId — INT — NOT NULL
- bandId — INT — NOT NULL
- name — VARCHAR(32) — NOT NULL
- phoneNumber — VARCHAR(32) — NOT NULL
- place — VARCHAR(32) — NOT NULL
- experience — VARCHAR(32) — NOT NULL
- introduce — VARCHAR(128) — NOT NULL
- pnp — VARCHAR(32)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
user
- id — INT — NOT NULL
- loginId — VARCHAR(32)
- password — VARCHAR(1024)
- salt — VARCHAR(128)
- phoneNumber — VARCHAR(32) — NOT NULL
- nickname — VARCHAR(32) — NOT NULL
- email — VARCHAR(32) — NOT NULL
- kakaoId — BIGINT
- loginType — VARCHAR(16)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP