b4
Tables (11)
News (Untitled7)
- Key (id) — bigint — Primary key — NOT NULL
- pid_id (id2) — bigint — Foreign key → PId.id — NOT NULL
- title — varchar
- body — varchar
- detail — varchar
- created_at (Field) — timestamp
- updated_at (Field2) — timestamp
PId (Untitled6)
- id — bigint — Primary key — NOT NULL
- title — varchar
- content (category) — text
- category (content) — varchar
- created_at — timestamp
- updated_at — timestamp
app_user (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar
- introduction (Field2) — varchar
- name (Field3) — varchar
- nickname (Field4) — varchar
- password (Field5) — varchar
- password_code (Field6) — varchar
- profile_pic_url (Field7) — text
- provider (Field8) — varchar
- provider_id (Field9) — varchar
- role (Field10) — varchar
- status (Field11) — varchar
- tlno (Field12) — varchar
- verification_code (Field13) — varchar
- created_at (Field14) — timestamp
- updated_at (Field15) — timestamp
board (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
- title (Field) — varchar
- name (Field2) — varchar
- content (Field3) — varchar
- image (Field4) — varchar
- count (Field5) — varchar
- created_at (Field6) — timestamp
- updated_at (Field7) — timestamp
board_like_user (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- board_id (Key3) — bigint — Foreign key → board.id — NOT NULL
- user_id (Key22) — bigint — Foreign key → board.user_id — NOT NULL
- like_status (Field) — boolaen
comment (Untitled4)
- id (Key3) — bigint — Primary key — NOT NULL
- board_id (Key) — bigint — Foreign key → board.id — NOT NULL
- user_id (Key2) — bigint — Foreign key → board.user_id — NOT NULL
- count (Field) — int
- content (Field2) — varchar
- name (Field3) — varchar
marsover (Untitled10)
- id (Key) — bigint — Primary key — NOT NULL
- camera_name (Field) — varchar
- earth_date (Field2) — varchar
- img_src (Field3) — varchar
- rover_name (Field4) — varchar
message (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
- title (Field) — varchar
- content (Field2) — varchar
- deleted_by_receiver (Field3) — boolaen
- deleted_by_sender (Field4) — boolaen
nasaimages (Untitled11)
- id (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar
- url (Field2) — varchar
- service_version (Field3) — varchar
- media_type (Field4) — varchar
- hdurl (Field5) — varchar
- explanation (Field6) — text
- date (Field7) — date
refresh_tokens (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL
- token (Field) — varchar
user_recent_password (Untitled8)
- Key — bigint — Primary key — NOT NULL
- user_id (Key2) — bigint — Foreign key → app_user.id — NOT NULL