scsa_prj2
Tables (5)
Users_Board_likes
- board_id — INT
- user_id — VARCHAR(50)
- liked — BOOLEAN
board
- id — INT
- title — VARCHAR(200) — NOT NULL
- region — VARCHAR(200)
- category — VARCHAR(200)
- price — INT
- content — TEXT
- address — VARCHAR(500)
- user_id — VARCHAR(50)
board_file
- file_id — INT
- id — INT
- file_path — VARCHAR(255)
- ori_name — VARCHAR(255)
- system_name — VARCHAR(255)
company
- code — INT
- name — VARCHAR(50) — NOT NULL
users
- id — VARCHAR(50)
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- class — int
- phone — VARCHAR(20)
- company_code — INT