user
Tables (4)
POSITIONS (Untitled3)
- position_id (Key) — BIGINT — Primary key — NOT NULL
- position (Field) — VARCHAR — NOT NULL
POST (Untitled2)
- post_id (Key) — BIGINT — Primary key — NOT NULL
- tag_id (Key2) — BIGINT — Foreign key → POSITIONS.position_id — NOT NULL
- title (Field) — VARCHAR — NOT NULL
- text (Field3) — LONGTEXT — NOT NULL
- recruit_count (Field2) — INTETER
- create_at (Field4) — DATE — NOT NULL
- last_modified_at (Field5) — DATE — NOT NULL
USERS (Untitled)
- user_id (bigint) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR — NOT NULL
- name (Field2) — VARCHAR — NOT NULL
- nickname (Field3) — VARCHAR — NOT NULL
- birthyear (Field4) — INTETER — NOT NULL
- created_at (Field5) — DATE — NOT NULL
- last_modified_at (Field6) — DATE — NOT NULL
WORKING_CONDITIONS (Untitled4)
- working_conditions_id (Key) — BIGINT — Primary key — NOT NULL
- price_per_day (Field) — BIGINT — NOT NULL
- Field2